Run-Time 3211 Error in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sub procedure that runs a make table query and then runs an append
query to the table created in the previous step. This works great until I run
it from a form that has a listbox control which gets it's data from the
above-mentioned table. When I run it in this manner I get a run-time error
telling me that the table is locked by another process or user. is there a
way for me to explicitly release this table prior to running the append or
some other work around that someone knows of?

Thanks!
 
You could programmatically reset the row source of the listbox, ie:
Me.[name of listbox].RowSource = ""
before your code and then:
Me.[name of listbox].RowSource = "SQL statement you had before"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DDL Query And Error 3211 2
Table In Use 2
Error 3211 delete table with multi-valued lookup field 7
Access #Error & Excel Pivot 0
How can I reset a database if Run|Reset doesn't work? 1
Error 3211 2
Runtime error 3211 1
Run time error "table opened exclusively" 2

Back
Top