When you are opening MYTABLE with SET EXCLU ON, an implicit opening of the DBC is attempted. Since EXCLUSIVE is ON, it tries to open the DBC exclusively. It can not do this because the other workstation has the DBC open.

The reason it works when you have SET EXCLUSIVE OFF and USE MYTABLE EXCLUSIVE is that the DBC can be opened shared but the table can be opened exclusively because the other workstation does not have that table open.

>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!