I get the error "Cannot access the selected table" sometimes when I exit my form. Is there an easy way to find out which table it is referring to?
I have a Click for my Exit Button that closes multiple tables (as many as 7 or 8 tables) using the following code for each table followed by the QUIT command at the very end of all the table close commands. Sometimes I get no error, sometimes I get the error once upon exit.
*!* Close first table
IF USED('table1')
SELECT table1
USE
ENDIF
*!* Close another table using commands similar to above
IF USED('table2')
SELECT table2
USE
ENDIF
*!* Close another table using commands similar to above
IF USED('table3')
SELECT table3
USE
ENDIF
*!* Then release and quit the form
THISFORM.Release
QUIT
Thanks for the help.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.