I have an app in which a ListBox is using a table called "Unique_Plans" as
its RowSource. On another form, I create some changes to one table and then
use a make-table query on the changed table to re-create the "Unique_Plans"
table. I get the following error message when I try this:
Run-time error '3211': The database engine could not lock table
"Unique_Plans" because it is already in use by another person or process.
I have tried setting the ListBox RowSource to "" first and then running the
query, thinking that this would release the table locks (since it is no
longer in use), but that does not work. Perhaps my whole approach is wrong.
Questions:
1 - Is there a way to overwrite the existing table without exiting the form?
2 - Is there a better way to accomplish what I want, i.e. to update the
table that is the RowSource of a ListBox and refresh the display with the
new records?
Thanks
Alan