repair database

[Guest]

I'm running access and compacted a database then decided to run repair - On
later versions of access it specifies compact & repair - I thought that this
just gave it a little more speed . I have tried to open this again and i
have lost all the indexes - please help - it took about a hundrtead hours
development time to get this database and i was just about to take a copy of
the compacted version when this happened

 

[Allen Browne]

What do you mean by "lost all the indexes"?

If you open your table in design view, and open the Indexes box (View menu),
are there any indexes listed there? Do you still have a primary key in any
table?

If you open the Relationships window (Tools menu), do you still have the
relationships between the tables? What happens if you click the "Show All
Relationships" button on the toolbar?

If a particular index is corrupted, then a compact'n'repair may delete the
index, but I've never seen it delete all indexes.