High school information system - Tech Support Forums

Toyo · April 8th, 2005, 06:02 AM

Am a desprate computer science student who has a project due in 5 days.Have been trying to finish it for a while now but can't. It is a high school information system project that has a visual basic 6.0 interface and a microsoft access database. I can't link the database to the interface. Please help!!

Fillie · April 8th, 2005, 03:06 PM

Did you look to see if there is a wizard inside Access that will do this for you?

originel · April 10th, 2005, 03:21 PM

How are you connecting to the database? there are a couple of different ways to do this: ole db, odbc, etc. C++ can't natively interact with a database, you have to use an interpreter (Which is what ole db and odbc are). Or have you even gotten this far?

Also are you using the CLI or are you using MFC/Win32API for a gui? Standard Library? We could use some more information about your project.

AgentCrypto · April 10th, 2005, 03:26 PM

Quote:

Originally Posted by Toyo

Am a desprate computer science student who has a project due in 5 days.Have been trying to finish it for a while now but can't. It is a high school information system project that has a visual basic 6.0 interface and a microsoft access database. I can't link the database to the interface. Please help!!

please post the form code .frm

originel · April 10th, 2005, 08:35 PM

aacck...i can't read...sorry i thought you said visual c for some reason...disregard my post

.

Toyo · April 11th, 2005, 01:18 PM

Am trying to link an existing microsoft access database to a visual basic interface.How is this done?

On the menu of the system there is a statistics button that is supposed to get data from the database and display it in a form of a graph to show the overall school performance.I can't seem to work out that part of the system.Any help would be highly appreciated.

P.s I also have a database which stores usernames and passwords.Users can not change their passwords.How can i enable them to do so without changing the username or adding on more users?

AgentCrypto · April 11th, 2005, 01:33 PM

Quote:

Originally Posted by Toyo

Am trying to link an existing microsoft access database to a visual basic interface.How is this done?

On the menu of the system there is a statistics button that is supposed to get data from the database and display it in a form of a graph to show the overall school performance.I can't seem to work out that part of the system.Any help would be highly appreciated.

P.s I also have a database which stores usernames and passwords.Users can not change their passwords.How can i enable them to do so without changing the username or adding on more users?

sounds like you want us to code the entire Application for you :rolleyes:

you will need to make a connection between the database & the application
to link the database -here's some sample code- :D
====
Me.OleDbConnection1.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _
"ocking Mode=1;Data Source=""C:\Program Files\TechIMO\sample0101.mdb"";Je" & _
"t OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.J" & _
"et.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security in" & _
"fo=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Create System Datab" & _
"ase=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without" & _
" Replica Repair=False;User ID=Admin;Password =techimo;Jet OLEDB:Encry" & _
"pt Database=False"
====
also remove the update code & hide the add users command from the GUI

****it all depends on how you got it setup****
send the .frm via pm or something
also you should post which version of ACCESS you are using..
:cool:

AgentCrypto · April 11th, 2005, 01:35 PM

if you are new to vb 6.0 programming use the database wizard under the tools menu

Toyo · April 14th, 2005, 12:01 PM

Hi!

Sorry have not checked mail latetly.Have been busy with my supervisor.He gave me a few days extension. Agent Crypto asked to to attach the form i am trying to code, but is'nt working.Any help would be welcome.

I have attached the form code

AgentCrypto · April 14th, 2005, 01:19 PM

Quote:

Originally Posted by Toyo

Hi!

Sorry have not checked mail latetly.Have been busy with my supervisor.He gave me a few days extension. Agent Crypto asked to to attach the form i am trying to code, but is'nt working.Any help would be welcome.

I have attached the form code

put the project files in a zip file then post it or pm it