Repairing a Back-End Database Question

[rmoreno]

I am trying to repair my back-end database but am having trouble. Everytime I select 'Repair Database' I get the following error:

'\\BE_Data.mdb' isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names.'

Can anyone tell me what this means, or more to the point, can anyone tell me how to fix this problem.

 

[WayneRyan]

rmoreno,

Obviously, I'd back up the DB, and try to import/export the data tables
while you can. If it was open, I'd retrieve/save everything I could
before exiting.

Links:

specific --> http://support.microsoft.com/kb/q158933/

general --> http://www.granite.ab.ca/access/corruption/symptoms.htm

Wayne

 

[ghudson]

The MS JetCompact utility will fix a sick db suffering from bad indexes.

 

[rmoreno]

Downloaded and tried the MS JetCompact utility. This utility is great. It was able to recover all my data with no known issues. Thank you for recommending this approach.

Thanks!!!