Memo field causing error message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jack - 26 Aug 2004 22:33 GMT

Hi,
I am running Access 97. One of the forms has memo field. When the user
updates records, most of those are fine. However, there are few where the
following error is generated:

3188, Could not update, currently locked by another session on this machine.

Any help is appreciated in advance. Thanks.

Reply to this Message

Tony Toews - 27 Aug 2004 05:56 GMT

>I am running Access 97. One of the forms has memo field. When the user
>updates records, most of those are fine. However, there are few where the
>following error is generated:
>
>3188, Could not update, currently locked by another session on this machine.

That table will need to be copied to a new table ignoring the
corrupted memo fields.

See the Damaged records within tables section in the To retrieve your
data from a Corrupt Microsoft Access MDB page at my website
http://www.granite.ab.ca/access/corruption/corruptrecords.htm

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

Reply to this Message