Locking Current Record

[Michael]

Hi Folks - I have a small db that might get accessed by up to 4 users. User
wants initial form to be browse only (allowedits = false). When user wants
to edit a record, user want to click button to allowedits= true. Once record
is edited, user wants to return to allowedit = false.

Is there a way to manually or programmatically lock the current record, or
should I rely on the built-in record-handling capabilities of Access. I am
using Access 2000. Thanks.

Also, I have another question related to multi-user databases ... Scenario:
User1 opens a form with allowedits = false. User2 opens a same form with
allowedits = false. User1 clicks command button to set allowedits = true.
Will User2 be able to make edits based on User1's action?


Michael

 

[Michael]

Hi Folks - I've been doing some thinking .... always dangerous. Here's what
I am thinking about this.

In the form's Current event, I will add allowedits = false. If the user
needs to edit the record, they can click a command button that sets
allowedits = true. When the user goes to the next record, the Current event
will set the allowedits back to false. Any comments or gotchas? It can't be
this easy!!!

Michael

 

[Guest]

Yes it can.