Results 1 to 4 of 4

Thread: Database engine cannot lock table

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2007
    Location
    Malaysia
    Posts
    1,370

    Database engine cannot lock table

    Why I got this error message? Why it happend?How to solve this?
    Attached Images Attached Images  

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    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.

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    Feb 2007
    Location
    Malaysia
    Posts
    1,370

    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

  4. #4
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    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
  •  



Click Here to Expand Forum to Full Width