record locking not recognized by access

[Award]

although a lock file is created, the computers in my peer-
to-peer network seemt "ignore" the fact that a record is
being edited, and allow the fields to be modified and
saved (with only a dialog box of warning). i would
greatly prefer that no editing of a record is possible if
it is locked. how do i get access to behave like this?

 

[Bruce M. Thompson]

although a lock file is created, the computers in my peer-

to-peer network seemt "ignore" the fact that a record is
being edited, and allow the fields to be modified and
saved (with only a dialog box of warning). i would
greatly prefer that no editing of a record is possible if
it is locked. how do i get access to behave like this?

Please post the text displayed in the warning dialog and the version of Access
that you are using. This may have more to do with multiple users accessing the
same "front end" file (or an MDB containing all objects including forms, code
and tables), if this is how your application is set up and you are using Access
2000 or later.

 

[Award]

Please post the text displayed in the warning dialog and
the version of Access

that you are using. This may have more to do with multiple users accessing the
same "front end" file (or an MDB containing all objects including forms, code
and tables), if this is how your application is set up and you are using Access
2000 or later.

The warning dialog says along the lines of, "the record
has been changed since you began editing. you can press
Copy to Clipboard to review the changes, then paste them
in if they are correct" and has 3 buttons, Save changes,
Copy to Clipboard, and Drop changes. I am runnign Access
2000 version 9.0.4402 SR-1. I used the database splitter
and placed the back-end file in a shared folder (this is a
peer-to-peer windows 2000 network). I copied the front-
end (forms etc) file onto all computers, and used the Link
Tables option to include the table information in my
database. When operations are performed on the data (like
editing a record), a lock file appears, and stays until
all of the computers have closed the tables. Each
computer's Access has been set to lock whatever record is
being edited. Yet I am not getting the expected behavior
(refusal to edit a record that should be locked), and I
don't understand why.

 

[Award]

I figured out what the "problem" was:

I had already created the form for editing the table,
BEFORE I had split the database into a front- and back-
end. It appears that the form keeps the editing policies
that were in place when it was created. By recreating the
form, I was able to get locking to work. (I tried setting
one PC to 'lock all records' mode and then creating the
form, then changing its mode to 'lock edited record', and
found that when I opened that form, it was attempting to
lock the entire file.) For the sake of knowledge, is
there a way to edit a particular form's locking behavior,
or is recreating it from scratch absolutely necessary?

Thanks,
Andrew Ward

 

[Award]

And I find that the Data tab of property sheet for the
form lets me change the locking behavior of an already
existing form. I apologize for wasting your time with
things I could find with just a little common sense and
searching. (The online documentation search engine could
definitely use some work, I think.) Thank you, though,
for reading and being willing to help me out, and making
this newsgroup a very valuable resource.

 

[Bruce M. Thompson]

I apologize for wasting your time with

things I could find with just a little common sense and
searching. (The online documentation search engine could
definitely use some work, I think.)

No need to apologize. It's good to see that you did manage to work it out on
your own, however, as that is the best way to learn. I never consider a posted
question to be a waste of my time. And yes, we have noticed some weaknesses in

Thank you, though,
for reading and being willing to help me out, and making
this newsgroup a very valuable resource.

You're welcome. *Everyone* who posts on-topic questions and/or answers here
makes the group a valuable resource.