Error message 1

[mannah07]

The error below pops up after closing a query I run in my menu, when I attempt to open the form of the table on which the query is running.

Error: Table in use. The table may already be opened exclusively.

 

[jimoo]

Is it possible that the form has it open already, or opening, exclusively in a private data session?

If the form is opening that way, make sure you add some code in the menu or form to check and see if it is open first and close it.

LOAD EVENT
* Close it if necessary
IF USED('myTable')
SELECT myTable
USE
ENDIF



Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[baltman]

A SQL command leaves the source table open. You'll have to add code to close it or otherwise account for this.

Brian

 

[jrajesh]

Please use the "?" icon when you post a question.
The 'bulb' is for tips.
Thanks,
Rajesh