Run-Time 3211 Error in Access 2003

M

MJatAflac

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!
 
M

Martin

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