Help: database corruption

[Veli Izzet]

Hi all,

I have a coruupted database because of a problem in one of the memo fields.

I get: 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 am using Access 2003.

I need quick help.

Thanks for answers

 

[Joseph Meehan]

Hi all,

I have a coruupted database because of a problem in one of the memo
fields.
I get: 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 am using Access 2003.

I need quick help.

Thanks for answers

For a start you can take a look at: http://allenbrowne.com/ser-47.html
scroll down to the memo field corruption area.

I can also add that you may be able to recover (note always work on a
copy of your database) if you can open the table and find the odd entries
and delete the record before and after. For some reason some memo field
corruptions seem to display the corruption in a good records data.

I will also suggest that memo fields seem to be subject to more problems
than text fields in some applications. I suggest using text fields if
possible. Text fields also take up less room.

 

[Guest]

Hi,

We had the same error message, and it caused our data to be mysteriously
replaced with oriental writing. The cause of the error turned out to be
write conflicts, i.e. one user has a record open and another user tries to
make changes. You should then get a warning message that tells you of the
write conflict and offers options. In my experience it's always better to
drop the changes and start again.

You can also cause a write conflict yourself if you have two forms open at
once that both relate to the same underlying table.

Another thing that might help is to regularly compact and repair your
database. Other than that, I'm afraid I don't have a clue!

Good luck.

 

[Tony Toews]

I have a coruupted database because of a problem in one of the memo fields.

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

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