FiveTech Support Forums

Hello Everyone,

Does anyone sample code on ADS management? I am looking for a couple specific examples.

1. If a record is locked by specific user, I would like to provide a message to user informing them of the user name that has locked the record.

2. If a DBF needs to be opened exclusively, however the DBF is opened by other users, I would like to get a list of users that are using the DBF

I would appreciate everyone's assistance.

Thank you,

Darrell,

I'm sure you will find some discussions of these topics if you do a search of this forum.

An alternate answer to question 1 is to use opitmistic locking. Using this a record will never be locked for more than a split second, so you won't need to know who locked it.

An alternate answer to question 2 is to reuse deleted records instead of removing them by PACKing the file. This would lessen the need to get EXCLUSIVE USE.

Regards,
James