I run an Access 97 database, 155 mb at the moment. It started to hang while running a query, did this repeatedly. I decided to "compact and repair" but it hung during the process. When I re-opened Access it was doing the error message about no valid index.

When the database is open I cannot view any tables or queries but it still opens the data entry form on launch and all the records appear to be still there.

I downloaded Jetcomp but it too hangs about half way down the progress bar.

Can anyone help? I am arranging to get a copy of the backup file from the network administrator, but am worried that this will have the original problem and I will get the same response.

Thanks