Getting (apparently) errors in single fields.

[DeanL]

Hi everyone,

I hope someone can shed some light on this for me but I seem to be
getting problems in an Access 97 DB and need some help on why it's
happening and more importantly, how to fix it.

Occasionally, one of the memo fields in my DB ends up losing the data
contained in it and only contains #Error. When I attempt to go into
the field to re-enter the data I get a message stating:

"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

First, I'm logged in exclusively so no one else is in the DB at the
same time. Second, when I click on OK, the cursor appears in the
field and allows me to type but when I leave the field, the DB pops up
the "Write Conflict" dialog box.

Any help with this little problem would be appreciated.

Many thanks, Dean...

[Rick Brandt]

DeanL wrote:

Hi everyone,

I hope someone can shed some light on this for me but I seem to be
getting problems in an Access 97 DB and need some help on why it's
happening and more importantly, how to fix it.

Occasionally, one of the memo fields in my DB ends up losing the data
contained in it and only contains #Error. When I attempt to go into
the field to re-enter the data I get a message stating:

"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

First, I'm logged in exclusively so no one else is in the DB at the
same time. Second, when I click on OK, the cursor appears in the
field and allows me to type but when I leave the field, the DB pops up
the "Write Conflict" dialog box.

Any help with this little problem would be appreciated.

Many thanks, Dean...

Those are file corruptions. If compact/repair doesn't fix them then you
have no choice but to re-create the affected records and then delete the bad
ones. If you don't know what the content of the memo field was then you
have to rely on a backup of your file to get that back.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[DeanL]

On Jun 6, 12:04 pm, "Rick Brandt" <[e-mail]:

DeanL wrote:

Hi everyone,

I hope someone can shed some light on this for me but I seem to be
getting problems in an Access 97 DB and need some help on why it's
happening and more importantly, how to fix it.

Occasionally, one of the memo fields in my DB ends up losing the data
contained in it and only contains #Error. When I attempt to go into
the field to re-enter the data I get a message stating:

"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

First, I'm logged in exclusively so no one else is in the DB at the
same time. Second, when I click on OK, the cursor appears in the
field and allows me to type but when I leave the field, the DB pops up
the "Write Conflict" dialog box.

Any help with this little problem would be appreciated.

Many thanks, Dean...

Those are file corruptions. If compact/repair doesn't fix them then you
have no choice but to re-create the affected records and then delete the bad
ones. If you don't know what the content of the memo field was then you
have to rely on a backup of your file to get that back.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thanks Rick, I'll try the compact/repair (long overdue anyway) and if
not I'll recreate the record.