A Database-Oriented Programming Problem 
Specifically, as soon as I type in "Dim Db As Database" and hit return, I get a msgbox with File Not Found error. If I bypass the line by commenting it out, database code further down the page gets the same error. I tried running Data Manager - same error. I tried using "Dim Db As New Database" - no good. The Data Control will load the Database address, but the other link controls won't see the database either.
I reinstalled fully, selecting no ODBC; again with no SQL; again with both; again with neither - same result. I searched the Institute's computer for additional files in WINDOWS\SYSTEM that I might be missing without success - the only difference between the two installations is that I am running 95 and they are running 3.1 with access to a server.
I really find it difficult to work after class time with all the chat in the classroom - which is why I got my own program in the first place - and now even that won't work. Any ideas?? I'd appreciate a quick thought and reply - I'm in the first week of SQL and would like to do some review of VB before it drops out of sight.
Thanks in advance for anything you can offer.
Jim Lynch
Email : lynchj@inforamp.net
I do know that to resolve any Database syntax VB actually uses the JET engine (the database engine shared by both VB and Access) and its interface layer to that engine. Specifically, these are a set of DLLs (MSAJT110.DLL, VBDB300.DLL).
It sounds to me that when it tries to verify your Data Access code it cannot find one of these DLLs. I would suggest that this means your copy of VBDB300.DLL is corrupt. If you have tried reinstalling and still had the same error you might want to try deleting these DLLs from your system before you reinstall (this will prevent the Setup program from detecting them and deciding not to overwrite them).
You might also want to try copying these two files from an installation of VB that you know works. If the compressed DLL on your install disk is corrupt, then this will verify that (and hopefully fix it).
Another tip: If you want to access Access 2.0 Databases you might want to try downloading a file called comlyr.exe (725 KB) - it updates the VB database layer with the version 2 engine. Pretty cool.
