MS Access Record locking

[Guest]

I have a fairly simple form which is bound to a table with a few fields. One
field in question is a memo field. On some occassions, when the user enters
data into the field, they get the following message; "Could not update;
currently locked by another session on this machine". Normally, the program
is run on a server, but the message also appears when run on a desktop. My
testing has discovered that the error seems to happen when a lot of data is
entered into the field (in excess of 500 characters). I thought a memo field
didn't have many limitations on size. I use recording locking as the program
is run in a multiuser environment, however, even if only one user is running
the program, the error still happens. Any suggestions
Bski

 

[Aaron Kempf]

Access MDB has random locking problems

move to Access Data Projects

 

[Guest]

I'm not familar with Access Data Projects. Is it another DB environment or
part of Office/Access?

Thanks Bski

 

[Marshall Barton]

I don't have an answer to your error for a single user, but
please do not waste your time on the rantings of that idiot.

 

[Guest]

Thanks .... And for what it's worth, I believe I have corrected the problem
by allowing the user to enter data directly into the form via a page field
rather than a balloon window, which allowed a much larger font when used on a
overhead projector as the original form font was too fuzzy. So my guess is
that Access interpreted both the open form and the balloon window as being
two users? However, I'm baffled that it only did when the characters exceeded
500.

Bski

 

[Marshall Barton]

Two separate processes are treated as two users they are
both trying to update a record so I agree with your guess
sounds right.

I don't see why you would not get the message in the same
situation regardless of the length of the text,