Please Help!!

  • Thread starter Thread starter Carlee
  • Start date Start date
C

Carlee

I work in Access 97. I have the following situation:

A mulituser environment
table, query and form record locking is set to Edited
Records
When two users open the same form, only the person who
begins editing first can edit any record in the form. The
other person is locked out of any record in that form and
cannot make any changes to any record for that form/

How can i solve this problem

Kind regards,
Carlee
 
check the settings when the mdb file is being opened. There is a exclusive
option, and when checked it only allows one person.

If you will on few occasions have just 1, or 2 two people in the database at
the same time, then you can get away sharing the just the file. However, if
you plan to have 3-5 people working in the database all day, then you REALLY
NEED to split the mdb into two parts. And, in fact, your users should get a
mde file.


Check out:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm

and

http://www.granite.ab.ca/access/autofe.htm
 
Sound as though your default record locking option is set
to "ALL RECORDS". Go to Tool | OPTIONS, Click on the
Advance tab to see what it is set to. See the help file
for more information.
 
Hi there,

Thanks for the help. I did some research and learned that
Access 97 does Page Locking for Edited Records. This, I
found, causes a group of records around the actual record
being edited, to also become locked.

Question:

Can i change this option such that i can have only that
record being edited, be locked? Or do i have to migrate
to Access 2000 to take advantage of this feature?

Kind regards,

Carlee
 
You are correct. The other possibility is to change your record locking to
optimize. That simply means that the groups of records is NOT locked.
However, if two users edit the same record, then the last user will be
informed that the record was changed, and is given a option to overwrite.

However, if you really do need single record locking, then yes, either you
move to a2000 and beyond, or roll your own routines.
 
-----Original Message-----
You are correct. The other possibility is to change your record locking to
optimize. That simply means that the groups of records is NOT locked.
However, if two users edit the same record, then the last user will be
informed that the record was changed, and is given a option to overwrite.

However, if you really do need single record locking, then yes, either you
move to a2000 and beyond, or roll your own routines.


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn


.
Thanks so much for your time. I appreciate it very much.
Click to expand...

Regards,
Carlee
 
Back
Top