Other SoftwarePost questions here about stuff not directly related to a specific OS (Applications, Games).
Mission Statement
WindowsBBS is an online community dedicated to easily accessible technical support for those using Microsoft operating systems and other Windows software.
Our goal is to become the leading resource for computer users that require assistance with their day-to-day computer usage, including full support for networking PC's, virus & malware removal, system upgrades and general support questions.
OK, you can't get to the second error without first encountering the first error.
The second error is very common, and is exactly what it says :Variable not defined.
The variable is probably defined at, or just after the point where the first error is encountered.
Could not lock file could EASILY be followed by one or more code steps to access data within the file and then define variables from it.
Hence, when the code is reached which uses the variables, you will get the variable not set error(s).
For purposes of expediency, I'll assume the database you're opening, is a "front-end" which accesses other (back-end) databases for its functionality.
There are numerous different methods access can make use of data from other databases, but the bottom line is, it must be successful.
If you could shed some light on what this front end does, or the types of databases to which it connects, and your network, etc, I might be able to shed some additional light on it.
Here is but one example: http://support.microsoft.com/kb/305995/en-us
Also, and this is VERY important:
Vista does NOT like many of the data access methods permissable within Access 2000.
If you have just recently installed this database on a Vista system, whereas the same code functioned properly on an earlier OS, you may not be able to resolve the issue without upgrading the database and changing some of the code.
One other thing, has this database been compiled into a MDE? if so, you cannot modify the code. Any solution would have to be external to the code.
