I'm working with an Access 2003 frontend with links to tables via ODBC to a SQL Server 2000 backend. I recently deleted some of the tables which were left over from a long time ago which have not been used recently, had little or no data in them, and never really were used all that much anyways. Call it spring cleaning, I guess.
Anyways, I deleted a table called "Allergy" from the backend and the link to it in the frontend. Now, when I try to delete a row (and perhaps if I even try to edit a row) in a table which I assume used to be linked to the table Allergy, I get the following error message:
"Could not execute query; could not find linked table". This is referred to as "(#208)".
I have looked at a Knowledge Base article which references this error, but it does not seem to apply to my exact circumstance. I have tried creating a new blank database, relinking all of the existing tables to the backend and then importing all forms/queries/modules, but this does not appear to have had any effect. I have also tried re-creating the .dsn which is used to make the connection to the backend, but this does not appear to have any effect. I have looked at the system tables to try to see if there was still some reference to the table Allergy in MSysObjects or MSysRelationships, but there does not appear to be any such reference.
All that seems to work is to re-create the old tables in the backend itself. i.e. I can create a new table in the backend called "Allergy", give it a primary key and just let it sit there completely empty and then I can delete the row from the other table without issue. Note that I did not have to add a link to the table in the frontend - I only had to re-create the table in the backend.
For the time being this works. This is a workaround, however, and not a solution, which is where I hope all of you can help! I'd love to be able to delete the Allergy table and the other three tables for which I get the same error when I try to delete them from the backend (all four tables are empty except for a key).
Thanks very much!