By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,838 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,838 IT Pros & Developers. It's quick & easy.

In trouble! Db locked with exclusive access

P: n/a
Hi gang,

Hopefully someone can help us out.

In short - Access 2002, db split into a front end and back end.
It appears that our backend db is locked. Our form bound to one table won't
allow new records to be created. When I open the table up directly,
attempts at a new record result in an error stating that the table is locked
by a user (me) who has opened the database in exclusive mode (from my
computer). The problem is that I do not have the database open in exclusive
mode. I can't seem to convince the backend db that there is noone locking
it into exclusive mode.

In the meantime, noone can add new records :(

Any suggestions?
Cheers!

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Wed, 07 Sep 2005 17:36:57 -0400, University of Toronto
<ph************@utoronto.ca> wrote:

Reboot all machines, and delete all .ldb files.
-Tom.

Hi gang,

Hopefully someone can help us out.

In short - Access 2002, db split into a front end and back end.
It appears that our backend db is locked. Our form bound to one table won't
allow new records to be created. When I open the table up directly,
attempts at a new record result in an error stating that the table is locked
by a user (me) who has opened the database in exclusive mode (from my
computer). The problem is that I do not have the database open in exclusive
mode. I can't seem to convince the backend db that there is noone locking
it into exclusive mode.

In the meantime, noone can add new records :(

Any suggestions?
Cheers!


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.