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

 

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

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___