General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Table in database will not open exclusively elsewhere
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only