Access/SQL Locking a Record if User has Record Open

[Nancy2]

Access 2000 Front end, SQL 2000 Back end, linked tables
Situation: User1 opens a record, another User2 opens same record. User1 may or may not have made changes before User 2 opens it.

User2 makes a change, saves record. User1 makes a change and we obviously have a problem. Error: The record has been changed by another user since you started editing it (clipboard...)

What I would like to have happen for User2 is to either lock the record or show a message box stating User1 has the record open.

Need ideas!

Thanks, nancy

 

[easyit]

Hi,

If in a query: In your query design view, rightclick and access the properties. There enable record locking.
if thru a form (which is bound to a query...?) same procedure.

By the way, if your sqlserver is on the network, you could solve this matters (and boost performance significantly) by using pass-through queries.

easyit