Connecting Tech Pros Worldwide Help | Site Map

In trouble! Db locked with exclusive access

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 13th, 2005, 01:28 PM
University of Toronto
Guest
 
Posts: n/a
Default In trouble! Db locked with exclusive access

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!


  #2  
Old November 13th, 2005, 01:29 PM
Tom van Stiphout
Guest
 
Posts: n/a
Default Re: In trouble! Db locked with exclusive access

On Wed, 07 Sep 2005 17:36:57 -0400, University of Toronto
<phil.mcfarlane@utoronto.ca> wrote:

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

[color=blue]
>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![/color]

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,840 network members.