I got this message and finally found a work around. My db contains all "linked" tables by using a make table query to read in and create tables from the main database with an autoexec macro. (This makes the database the most recent data every time it is opened, but makes it a "read only" type database - where the inquisitive user can't mess up the data). (Using Access 97)
I put an "x" in front of the problem database filename. Created a new database of the original filename. Imported all queries, tables, etc. - without importing tables from the "x" database.
Problem went away.
I also tried to compact/repair the database. It said it did successfully, but the file size never changed. This indicated to me something inside the database was messed up and I guessed it had something to do with the tables.
I put an "x" in front of the problem database filename. Created a new database of the original filename. Imported all queries, tables, etc. - without importing tables from the "x" database.
Problem went away.
I also tried to compact/repair the database. It said it did successfully, but the file size never changed. This indicated to me something inside the database was messed up and I guessed it had something to do with the tables.
