Table relationships broken

[clmarks]

I have a database which has been running well for four years. There are four tables that are linked from one to another in a one-to-many relationship, i.e., Table1 to Table2 to Table3 to Table4. We recently had a power failure and our network went down. Now the relationship between Table2 and Table3 is broken. When I try to rejoin them using the Relationship View, Access tells me that the relationship between the tables is "Indeterminate". I have run queries testing for unmatched records between all of the tables and the data appears to be fine.

My only guess at this point is that the structure of one of the tables is corrupted. The problem is that each of the tables has an autonumber field. If I build a new table structure, and append my old data, isn't that going to renumber all of the records?

I have run a compact and repair on the database and that didn't help. I have made copies of the tables and tried to use them in the relationships. The copies don't work either. Other than not being able to link the two tables, everything is working fine.

Does anyone have any ideas?

Thanks,

Cherry

 

[gemma-the-husky]

try repairing the table

if that fails create a blank database, and reimport everything - that wont mess up your autonumbers

if that fails create a blank database, and export the tables one at a time - that wont mess up your autonumbers

open the tables - sometimes there is corrupt data visible IN the tables

------
there clearly is a corruption of some sort

------

copy it first before you start messing with it, as you may do more damage

finally do you have a recent backup you could revert to?

 

[GaryPanic]

do all of the above - but do it on a local pc - not accross a server

will work quicker and better once fixed shove it back ontot he server -Ensure you ahve copies before you start

 

[clmarks]

Thank you both for your help. I tried your suggestion, but I'm afraid that nothing worked so I'm having to rely on a backup from Friday. I really do appreciate the support from this group.

Cherry