FiveTech Support Forums

Some times my clients leave locks open on the server ( ADS versions 7 to 9 ), perhaps by Ctrl-Alt-Del or power failure. Then if we try to get an exclusive lock ( ie. reindexing ), it is denied.

I know the lock table is maintained on the server ( Advantage Database Server ? ). Is there a command, or process, we can perform on the server ( other then a full reboot ) that will clear the ADS ( Windows ) lock table of all locks placed by all workstations ?

Tim

Timm,

AdsMgGetLockOwner() indicates wthat user has a locked record into a dbf.

AdsMgGetLocks() indcates all records locked.

You can use AdsMgKillUser() to disconnect a user.

AdsWriteAllRecords() writes all pending data and releases all locks.

Hope it helps.

Regards,

Thank you.