Doanair
asked on
Row level locking with MSAccess 97, VB6, & ADO
I have an application running on multiple computers, processing items from the same database table. Only one computer may be accessing a record at one time. Each record must be opened and remain locked until processing is complete (when processing is complete, the record is updated with new data). How may I grab the next available record without grabbing a record currently in use by another computer/user?
The record will automatically be locked when u are editing it...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER