-
I am a VB Newbie. Modified an existing program that inquires into an Access database on a LAN. The VB5 Program uses dbgrid & comdlg. Program runs fine from my developer workstation (running NT). Used package & deployment wizard to create setup module & associated files in a network folder. Used that setup to load program to other workstations (some NT some 95). The workstations that had the old version of the program running work fine. The workstations that did not already have the old program loaded are getting an unknown error at the OpenDatabase
with the following line of code(code is on 1 line in program but split here for reading ease).
Set dbWork =
DBEngine.OpenDatabase(strDatabase_Location, ,True)
The strDatabase_Location is the network path to the database. The database is being opened as shared, read-only.
The user has all necessary rights, the database is not password protected. The user can manually navigate to the database and open it. WHERE DO I GO FROM HERE PLEASE??
-
First thing to look at would be if you have the proper version of MDAC installed on the machines that are having problems.
-
THANKS. That solved my problem. Next question, Why did I not see any refernce to this small detail in ANY of the reference manuals & documentation. As a newbie I am discovering that sometimes you have to know what you are doing to find out how to do it!! If I knew what I was doing I wouldn't have to search out instructions. Oh well, guess that's why VB programmers are so valuable.
Thanks again.