Help Please with EditMode Property

  • Thread starter Thread starter David Ehrenreich
  • Start date Start date
D

David Ehrenreich

Hello,

I have my Database setup with a backend and several
instances of the same form. The frontend form is linked to
the backend tables. Their are several of these frontend
stations. What I like to do is when a user is working
with a record another user on another station wont be able
to enter into that record for editing. I would like a
message box to appear telling the user to try again at
another time. I was told about EditMode Property
function, but i'm a little clueless on how to use it. I
don't even know if this is the right way to go. Any help
with this would be great.

David Ehrenreich
 
If you are using Access 2000 and above, you can have
Access lock the record when a user begins editing it and
unlock it when they save the record. This is done by
setting the Default Record Locking to Edited Records and
checking the "Open database using record-level locking"
box in the Options dialog.
The downside to this method is that if a user were to try
to edit a record that is locked, Access won't let them
edit the record (which is what you want) but there is no
message that pops up telling them that someone else is
editing the record (only a little circle with a line
through it and that is only if you have the Record
Selectors set to True).
Paul Litwin and Ken Getz have a nice example of how to do
this with a form in their book, The Access Developer's
Handbook. I can send you a sample database if you like.
 
Back
Top