a) if the table is open in another datasession then you cannot open with exclusive access. b) if the table is open in this datasession with no exclusive access, then you cannot open again with exclusive access. SET EXCLUSIVE OFF USE MyTable IN 0 * NEXT exclusive is ignored : A BUG for me, correct is fire a ERROR USE MyTable IN 0 AGAIN EXCLUSIVE c) if the table is open in this datasession with exclusive access, then you can open again with exclusive access, but you cannot do a pack command. d) if you open the table with exclusive access, and do a PACK, VFP copy the dbf,memo file and structured cdx; for do this operation, VFP release the file handles and after reopen the packet table; this lose the workarea configuration.Then, for a correct packing you must
** IF I CAN DO A PACKING USE Mytable EXCLUSIVE PACK USE && unfortunately, on VFP EXCLUSIVE is a readonly property ** END PACKING ** now use the table and set recno(),order(),filter(),key,fields ....This have a implicit result: