Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table in database will not open exclusively elsewhere
Message
From
09/01/2002 12:44:25
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Table in database will not open exclusively elsewhere
Miscellaneous
Thread ID:
00602588
Message ID:
00602588
Views:
59
I have a table (mytable) within a database (mydata).

I have these commands:
SELECT * FROM mytable INTO ARRAY aArray
USE IN mytable

After issuing those commands, at a different workstation,
I typed in these commands:
SET EXCLU ON
USE mytable
MODI STRUCT

mytable will not open. Error message:
Database mydata.dbc: File access denied.

I had closed mytable table (USE IN mytable),
but since the table is in mydata database, I cannot open up mytable exclusively elsewhere (without closing mydata database altogether)?

What I'd like to have is to retrieve data from myTable, and when that's done, to be able to open up myTable exclusively elsewhere (so that I can MODIFY STRUCTURE whenever I need to), without closing the whole mydata database.

Can anybody shed light?
Thank you all!
Next
Reply
Map
View

Click here to load this message in the networking platform