I was making extensive changes to a database regarding the tables. I renamed a whole bunch of tables and then deleted some. Now I have a message 'The table links for this database are not valid'. I deleted all the table links from the front end then relinked all and still got the message. Finally I created a brand new database and imported all the objects from the old database. Then relinked all the tables. I still get the message. I'm at my wits end! This has never happened to me before in 10 years of working with Access. Anyone got any ideas what could be happening? This is Access 2003 and a split database.
Further update:
I created a brand new front and back end and imported all the objects. I deleted all the links from the (brand new) front end. I then tried to compact and repair the front end then immediately got the message 'The table links for this database are not valid'. I went to tools--linked table manager and it said 'no linked tables in database'. I then re-established all links and again attempted to compact and repair - got same message 'The table links for this database are not valid'. Using the front-end links, I can open and view all the tables. I have run out of ideas. Help/suggestions needed.
Further update:
I created a brand new front and back end and imported all the objects. I deleted all the links from the (brand new) front end. I then tried to compact and repair the front end then immediately got the message 'The table links for this database are not valid'. I went to tools--linked table manager and it said 'no linked tables in database'. I then re-established all links and again attempted to compact and repair - got same message 'The table links for this database are not valid'. Using the front-end links, I can open and view all the tables. I have run out of ideas. Help/suggestions needed.