Lockout Errors

B

baconroll

I am running a database which is shared by many users. Occassionally a user
gets the following errors in order of 1. Could not save, currently locked by
user etc, (press ok) then you get 2. The save operation failed, (press ok)
then you get 3. Out of memory.

I have determined that the user was not in a record that someone else was in
- any ideas on why this is occurring. thanks
 
T

Tony Toews

baconroll said:
I am running a database which is shared by many users. Occassionally a user
gets the following errors in order of 1. Could not save, currently locked by
user etc, (press ok) then you get 2. The save operation failed, (press ok)
then you get 3. Out of memory.

I have determined that the user was not in a record that someone else was in
Click to expand...

Access defaults to working page locking mode rather than record
locking. So it's quite possible that someone could be in an adjacent
record causing this error message.

That explains 1 and 2. However 3 out of memory should not be
occurring. That makes no sense at all. Are you up to date on your
service packs on all your systems?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top