Results 1 to 2 of 2
  1. #1
    heinensk23 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    13

    Run-time error 3211 when trying to update datta


    I have a subform in a form. The data for the subform is created using a make table query. I created a command button to close the form, run the make table query, then open the form up.
    In the middle of the make table query process, it shows the run-time error 3211 saying it could not lock the table because it is already in use.
    How do I fix this?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    probably a timing issue, you haven't mentioned it but presumably you are deleting the previous version? And there are no other forms/reports/queries open which would prevent the previous version being deleted?

    Constantly deleting and remaking tables is not good practice, it leads to bloat. Better to just delete the records and then append the new ones - or perhaps a mixture of update and append if appropriate

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Runtime error 3211, delete table, append DAO properties
    By cfrancisco523 in forum Programming
    Replies: 5
    Last Post: 07-05-2017, 10:24 AM
  2. Run-Time 3211 Error After OutputTo
    By hockeyman9474 in forum Access
    Replies: 3
    Last Post: 03-02-2017, 02:37 PM
  3. Error 3211 - table in use by another
    By D'Anconia in forum Forms
    Replies: 4
    Last Post: 05-19-2014, 05:28 PM
  4. Error 3211
    By Phred in forum Programming
    Replies: 1
    Last Post: 01-25-2012, 10:29 PM
  5. Error 3211 Object cannot be locked
    By TheShabz in forum Forms
    Replies: 9
    Last Post: 08-23-2011, 12:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums