I have a two shared *.mdb databases, both of which have linked tables. The databases are shared on a University network across three subnets and used by up to 20 users.
Mostly the databases run smoothly so long as the first opening on one day happens on one subnet. If a user on another subnet opens one of the databases before any one else, it causes both databases to be locked to other users, and we get a “Could not use ‘(Database Path)’; File already in Use”, followed by a similar error message with a reference to Code 3045.
If the User on the bad subnet closes down allowing a User on the Goood subnet to open first, the original user can then open and things carry on without a problem.
This is not Permissions based as Permissions are Group based and assigned. It is not Hardware based as it is independent of the machine being used. It is not installation based as the software and all SPs are rolled out centrally. It is not a Users network profile as I have had those reset, and the error persists.
All I can think is that somehow the subnet is affecting the database locking.
Any ideas anyone?