Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access/SQL Locking a Record if User has Record Open

Status
Not open for further replies.

Nancy2

Programmer
Joined
Sep 18, 2001
Messages
97
Location
US
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
 
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top