Updating linked tables after conversion

[Johnny Drama]

Hello all,

I've recently upgraded a 2003 database to 2007. When I try to update the linked tables using the linked tables manager it shows the tables in the old .mdb file. When I select the new .accdb file and then try to start the update it gives the following error message: "The Microsoft Access Database engine cannot find the input table or query named 'table name'. Make sure it exists and the name is spelled correctly." All of the table names in the link manager show the .mdb file.

Thanks in advance for any help.

 

[PaulO]

Sounds like you have, perhaps, removed a Table from the new database?

 

[Johnny Drama]

Nope, all of the tables are still there.