DAO/Access Record Locking Problems

[soundmangav]

Hi,

Is there anyway of preventing multiple users from accessing the same record when using DAO & VBA for Access '97. I've tried using a 'Locked' field in my main DB Table, so that whenever a user retrieves a record it sets the 'Locked' field to 'True' thus preventing any susbsequent users from retrieving the same Record (ie. the search criteria states the Locked field must be False in order to retrieve a Record). However, if say 2 users click 'Next Record' at approximately the same time, then they are both still presented with the Record details, and the trapped error handling only becomes effective when one of the users attempts to edit/update the Record.

Is it possible to overcome this problem when developing a DAO & Access '97 VB Application so that the same Record is never presented to more than one user. Is record level locking available with DAO/Access '97 ?

I'd really appreciate any suggestions anyone can offer me!

Cheers for your help.

Gavin.

 

[PaulBricker]

There is a RecordLocks Property for a Form. The easiest thing is to open a module, and go to Help. Type in RecordLocks. This should bring up the information you need.

Paul