Compacting Error on .mdb Back End

[Paul H]

I added an Autonumber to a "largish" table that never had a true primary key. There are 165,000 records. There is a 5 part composite one that makes my head spin. I have kept the Back End as an .mdb file since we were in a transition period and still are to an extent. The new front end is an .accdb file. So the rub is when I try to compact it I get this error.



I'm not sure what to make of this. I'm considering deleting the Autonumber field, since I'm not sure I want to do all the dirty work of incorporating it throughout the application.

Any thoughts.

[ranman256]

it could be because youre using 2 different versions. I had this once.
Can you make both ends in the same version?

[Paul H]

I saved it as an .accdb and now it compacts normally. My intention was to preserve the .mdb back end as an escape hatch in case the old front end was needed in an emergency. I'm a little disappointed that I can't do so. Not too surprising considering Access 2003 is quite old. It has worked perfect as a back end, till now at least. Suppose it's time to move on.

Thanks for your help.

Paul