Feb 15th, 2008, 08:24 PM
#1
Thread Starter
Frenzied Member
Database engine cannot lock table
Why I got this error message? Why it happend?How to solve this?
Attached Images
Feb 16th, 2008, 06:32 AM
#2
Re: Database engine cannot lock table
That isn't very much information to go on, so this is nothing more than a guess.
You have an Access database, and more then one person is attempting to access the same record at the same time.
If you give some more details, perhaps a more solid conclusion could be arrived at.
Feb 16th, 2008, 06:45 AM
#3
Thread Starter
Frenzied Member
Re: Database engine cannot lock table
Nobody access the Microsoft Access except me, I am not using server just desktop compute. I use ADODB connection and the record set
Feb 16th, 2008, 12:50 PM
#4
Re: Database engine cannot lock table
It sounds like you are trying to do something which requires exclusive access to the table, but your other code is already using it (perhaps via a recordset that you have forgotten to close) or even Access itself (if you have it open in an Access window).
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width