AO Index is not an Index in this Table

[Lochwood]

Whenever i Compile and repair my front end i get error half way through.. "AO Index is not an Index in this Table" i click ok and find most of my table links, forms and some queries have gone. the database is then unusable. luckily i have a backup before the compile and repair so can restore it.. i have tried unlinking all tables but the issue still exists.. i am running a 2003 database with switchboard and userl level security on a 2016 access platform.

Any thoughts?

 

[arnelgp]

are both 32 bits or both 64 bit office.
they don't go well together.

also a2007 up to 2019 uses new accdb structure (a2007 structure).

 

[Lochwood]

Both 32Bit

 

[arnelgp]

there area additional system tables since 2010.
so using 2003 and 2016 is not compatible.
when opened on a2016, it will add additional Msys tables.
if opened in a2003, it will complain of something, worst it might never recognize it as a database.

 

[Cronk]

The OP wrote

Whenever i Compile and repair my front end i get error half way through.. "AO Index is not an Index in this Table"

If your system is split FE/BE, then if there is a table(s) in the front end, it should be a look up table. I'd import all non table objects into a new db and re-create the lookup table.

 

[isladogs]

I haven't seen the AO Index error for many years.
Its due to corruption in an Access system table MSysAccessObjects.
Luckily there is a fix by Dirk Goldgar that should solve your problem without having to do so step by step as previously suggested.
See http://datagnostics.com/dtips/fixaoindex.html

Hope that helps