Macro Fails Due to Table Locked

[LLFK]

I have a standalone form with a page that contains a subform linked to a
query. In order to update the subform data, I created a macro to run several
queries that will ultimately update the query the subform is linked to. In
my macro, I close the main form, run all of the queries and then re-open the
main form with a GoToControl to get it to go right back to the page where the
subform resides. I continue to get an error with my macro that states it
can't run my queries because the table is already in use.

When I manually close the main form and run the macro, it works fine.

Any thoughts?

 

[Ken Snell \(MVP\)]

The form is not closing fast enough for your queries to be able to gain
access to the table. This likely is a timing issue. Any particular reason
you cannot update the data directly in the subform without having to run the
external queries?

Otherwise, you'll need to run a macro to close your current form, open
another form, and then run a macro from that form that will do the updates
(that should ensure that the first form is fully closed).