>Dear Jim
>
>Thanks for the answer. But again a question came in my mind, if a file is always opened exclusively and if I include AGAIN in USE command then how it is possible to maintain the EXCLUSIVE mode.

The file is open exclusively to a workstation. On that same workstation (and in the same data session) you can USE File AGAIN in a different work area and it is open exclusively in both work areas. The key word AGAIN is used to allow a file to be open in more than one work area on the same workstation.

>In MSDN help also I found that they say the file will open again with properties as the 1st file open ie. more than one user can open the file in EXCLUSIVE mode simultaneously.

This is true. For example;

USE Table1 ORDER Name
SELECT 0
USE Table1 AGAIN ALIAS Table2 ORDER Name
* Right now the table is open in two work areas
SET ORDER TO Name DESCENDING
* Now the order in theTable2 work area has been made descending
SELECT Table1
BROWSE
* This browse shows the order being descending because the change in Table2
* work area also changed the Table1 work area

The AGAIN clause does NOT allow the table to open by another work station. Also the AGAIN keyword will NOT allow the an exclusively open table to be open in another data session.