Discussion Locked

More error 3045 database Access 2003 dbase lock

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

1 reply

by brockadam

I ran into the same error and I found the cause to be an empty toolbar that I had setup in the prior version of MS Access. The toolbar was named Custom1 and was set up in the Tools\Startup as as a Menu Bar:Custom1, but not in the opening form; I did this so that the form would open up clean with no tool bars. I guess MS Access does not like empty toolbars so I added a Blank choice and voila. Now its working. If still you get error that means your database is critically corrupt. Last oprion is use access repair utility http://www.repair-access-file.com

Gud luck

This discussion is closed to new replies.