>once again, i hv some problem on this topic again, if it is possible to do the PACK comaand when everytine the user log?!
>if yes, after the PACK command finish, will other user disconnect to the DB again?!

Wai,

The OPACK commadn requires exclusive use of the table. Other users cannot open a table that is opened somewhere exclusively. Also, no one can open a table exclusively if any one else has the table open (either exclusive or shared).

Packing is not something you want to do automatically. You want a supervisor to detemrine that everyone is out of the system and then run a program that will do the packing of the tables.

The point is this, packing REQUIRES exclusive use, exclusive use is something you don't want in a multiuser system, therefor you don't want to pack in a multiuser system. If it is absolutely necessary to pack then make it a special function that is limited to supervisors and only done after hours when the rst of the users are not in the system.

If you SET DELETED ON you will not see the deleted records. None of your commands will touch the deleted records, your reports will not include the deleted records. For all practical purposes the deleted records will not be there. Paxcking only physically removes them from the table.