ACCESS FEED: Re: [MS_AccessPros] updating a recordset that is opened in a form

Kamis, 27 Maret 2014

Re: [MS_AccessPros] updating a recordset that is opened in a form

Onno-

If this code is running inside your form or is called from your form, the form cannot close until the code completes. Even though you have issued a Close command, the form is still open, so you can't delete the table. Consider instead deleting all the rows in the table and then use INSERT instead of SELECT … INTO to reload the table.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Mar 27, 2014, at 9:54 AM, Knol, Onno <onno.knol@pbl.nl> wrote:

Dear Pro's

I have a problem with unlocking a table.
I have a form that is populated with a recordset that is a query on table calcMSA.
On the form I have a button recalculate. This will delete the table calcMSA, perform a set of complicated queries and re-create the table.
The first thing the button does is close the current form, doevents and then continues the update procedure.
However the procedure fails on the statement to delete the table calcMSA, even when the form is closed.
Apparently the lock persist. Any way to unlock it?
By the way if I run the recalc form another form that does not have the table open, it runs flawlessly.

Hope for some help,

Onno Knol