I have a replicated database in which one of the primary tables has apparetnly been corrupted.
The symptom is that I cannot add to/modify the design of the table at the design master as I get a message that the table is locked by another session on the machine.
After some trial and error, I discovered that I can modify the design of other tables, and we came to the conclusion that this table is corrupted.
How do I fix this issue? The table is replicated and has numerous relationships to other tables in the database?
If I copy the table, is not the corruption going to remain in the copy also?
TIA,
M Scott

Have you run a repair and compact on the database?

Make a backup copy of the database then run repair and compact.
Tools->Database Utilities->Repair and Compact.

I wish it were that easy. I have done a C&R numerous times w/o affect.:mad:

Can you export the data from the table to a text file, delete and rebuild the table (and relationships) and re-import the data?

Also - MSFT has a repair tool available at support.microsoft.com called jetcomp.exe (http://support.microsoft.com/default.aspx?scid=kb;EN-US;172733) that does a better job of repairing databases that what ships with Access. I have had to resort to it on two occasions and it solved my problem.

Also you may try the tip here (http://support.microsoft.com/default.aspx?scid=kb;en-us;302498).

more ideas (http://support.microsoft.com/default.aspx?scid=kb;en-us;279334)

(actually some or all of the above may be useless depending on what version of Access you have)

Good luck!