Background: I have a sql database with an access front end that I use to enter timecard data. The tables did not conform to company naming conventions, so I renamed the tables, deleted and re-linked them in access and changed the appropriate code. So far, no problems, but when I requery one of the forms I get the following error message:
Could not execute query: could not find linked table.
[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'OldTable'.(#208)
The access front end is now linked to 'NewTable' and the data is entered into 'NewTable' with no problem. The error only occurs when I try to requery one of the forms. As far as I can tell there is no reference to 'OldTable' on any of the forms. I did a search for 'OldTable' in the code and nothing came up. I am able to open all of the linked tables in the access front end. There is no reference to 'OldTable' in any of the stored procedures.
My work-around for now is that I've recreated 'OldTable' with no records in it and the requery works fine. The data is still going into 'NewTable'. There are 2 columns that must exist in 'OldTable' in order for the requery to be successful. I deleted all the other columns.
My goal is to delete 'OldTable' as there are never any records in it. I've spent a lot of time on this and have come up empty so far, so any help would be greatly appreciated.