Microsoft database engine error

[jpinto1167]

I do have one table in one database that got corrupted. There is no problem getting data from the "Customers" table on my forms, reports and queries. The problem is that when I try to compress the database using Microsoft Access Compression tool or jetcomp I do get read access errors. Then If I try to copy or import the objects from this database into a new one I always get an error on this table saying that the "The microsoft database engine stopped the process because you and another user are attempting to change the same data at the same time"

What could I do?

Thank you

 

[jpinto1167]

I actually found out that there is a memo field called "Notes" that is the one guilty for the corruption. It has lots of data that I can not export or do anything with it. Any idea on what to do ?

Thank you

 

[PHV]

If you don't have recent backup of the non corrupted database you may try to retrieve the Customers records without the memo field in a make table query to get a new hopefully non corrupted Customers table you can then export.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244