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"
 
Back
Top