Table In use Error 1

[smartglass]

Hi there:
I am getting a 'Table in use. The table may already be opened exclusively ' error when I run an application. I use queries to get data from Oracle then load a second form from the tables that result. Running this second form generates the error.
However, when running VFP itself, not the app, I get no error.So I can run fine but my users cannot!
Here is the code on the primary, query generating form:

SET EXCLUSIVE ON
DO r:\data\stillages\qloads.qpr
DO r:\data\stillages\qloaded.qpr
USE still!stillages
APPEND FROM R:\Data\stillages\loaded.dbf
CLOSE TABLES
SET EXCLUSIVE OFF
DO FORM r:\data\stillages\stillage.scx


So I was sure that the tables were not opened exclusively.
Could anybody help, please?
Thanks!

 

[dgrewe]

Command "CLOSE TABLES" - Only closes free tables.
You have a Database/Table "Still!Stillages" is open so the "close table" command does not effect the DBF it is associated with the DBC.

Try
"CLOSE TABLES ALL"
"CLOSE DATABASE ALL"
or
"CLOSE ALL"
instead of "CLOSE TABLES"

David W. Grewe (Dave)

 

[smartglass]

Thanks, DW...that did it!