Operation invalid without a current index. (Error 3019)

[Len Boorman]

I am getting this error when I try to look at the tables of a database that was working fine.

Basically it says reset the index to recover.

Anybody out there who can explain in simple terms how to reset the index

Len B

 

[mdemarte]

First, make sure you and all other users are out of the database. Second, make a copy of it, just in case. Third, go into the database and select Tools, Compact and Repair Database. Hopefully, that will fix the index.

 

[WayneRyan]

Len,

If Compact/Repair doesn't work...

You can get your table in Design View and use the Index
Manager (the lightning bolt) to manually drop, create,
and define concatenated indexes.

Wayne

 

[Len Boorman]

Thanks for the comments

Unfortunately I cannot actually view the tables in design view to fiddle with index's, Also Compact, Repair comes up with same error, Copy got nowhere either.
Now curiously
Another application was used to analyse the data in the tables so it was using linked tables.

Using a third application I was able to link to the second that linked to the problem application. I used a make table query to import all of the data and my documentation to define primary keys and relations. I was then able to import all Forms, queries etc from original application and therefore rebuilt the application.

Seem to have escaped .

Quite why ot how original problem occurred I can not be sure but our network people have been changing things about and certainly at times they managed to confuse everybody including themselves. This was the third application in a few days with a problem

Cheers

Len B