Unable to open database

[mikemaki]

Here's one for the techies out there:

Below is the error message that we get in the Cardiology Database when the file gets locked. Once the file is locked, any user that attempts to launch the database will get this message prior to the login screen(our security splash screen).


Microsoft Access was unable to open the Visual Basic project for this database

Another user is saving the projet now. Do you want to retry?


We generally solve the problem by:

1. Identifying the PC that has either the .mdb or .ldb file locked (Tech)
2. Deleting the Connection in Novell (Tech)
3. Re-Booting the PC so that it does not re-establish the connection (Apps or User who reported problem)

This used to happen about once a month, but it seems to happen a bit more often now, and we are adding more users to the database. Any info you can find on this from the Access user groups you belong to would be helpful.
Thanks.

 

[Adrianna]

How many concurrent users are accessing the database?
Are the ldb files deleted everytime a user locks the database?
What is the refresh interval in the database options menu?
Is their a commonality amongst the user level priviledges that are locking the system?

I'm not sure if the solution that you seek will be found by asking yourself those questions, but it couldn't hurt to srtat there...or provide that information to the forum so that they will be better able to assist you.