Access Error

[tpearo]

I have an Access 97 database that has a table with a few different memo fields in it. This is a multiple user database and I am getting an error message that says !The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. I have narrowed it down to a memo field in one of the tables that has #Error in it instead of the proper data. I remember reading about this problem in another forum and the solution was to upgrade the msjet.dll file to msjet35.dll. I have done that and still am having the problem. I would like to try to resolve this without deleting the record that contains this erro field because this table contains an auto/count field and the record has alot of data associated with it all referenced by the auto/count field. Can anyone suggest a fix. I've tried repairing the data container, but that does not eliminate the problem. I've also compated the data container... no luck. Help!!!!!!<br>&nbsp;

 

[gyma]

Yo tpearo _<br><br>Checkout the following posts - (Re: Record locking) and (Re:Write confict error) - <br>..hopefully you will find a solution there_<br><br>gyma&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: {

 

[xtreme1]

&nbsp;&nbsp;&nbsp;&nbsp;I run into those errors often, or used to I should say.&nbsp;&nbsp;What you can do, or what I do here is, cut the record from the table it's in and repaste/append it.&nbsp;&nbsp;Write down the autonumber it was at previously first of course, and then write down it's new autonumber after you paste.&nbsp;&nbsp;In any tables related with that record, query out the previous CustID that you wrote down first, and change it to the new CustID number you got after pasting the record back into the table.&nbsp;&nbsp;This way, the record will be viewable as normal and the &quot;Error&quot; will no longer be active and you can write in your memo fields again.&nbsp;&nbsp;Unfortunately, there is no way to retrieve the memo field data..=(&nbsp;&nbsp;But at least you won't lose the entire record.&nbsp;&nbsp;Good luck! <p>xtreme1<br><a href=mailto:rbio@excite.com>rbio@excite.com</a><br><a href= > </a><br>