Software

Ask something
Discussion Locked

Access 97 Shared Database Locking Errors

0 helpful
5 replies

by kdjenk

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

I have developed an Access 97 Database that 5 of my coworkers share. They are all entered as users with full permissions with myself as Admin.
Frequently, when more than one person is using the database, and they go to close, he/she gets an error that will not let them close out. The error says something to the effect of "Couldn't lock/save...currently in use by user [insert user name here] on computer [insert computer name here]." I have taken off all record locking options, but still get this error.

5 replies

by john_wills

Just a thought: what actions happen at close of the database? Perhaps you are trying to do something that cannot be done while someone else has the database open.

by kdjenk

Well, I considered that at first, thinking one of my users might be going into design mode on a form while someone was using it...but after careful tracking, that's not the case. Currently I am trying to split the database...although I keep gettingerrors about the relationships when trying to do so, so we'll see.
Thanks.

by paulp

When you installed Access97 on the computers, did you select ALL ACCESS components? The default installation of ACCESS does not install everything necessary to share database files.

by kdjenk

I have checked on the installation and that should not be a factor.
Thanks.

This discussion is closed to new replies.