could not execute query; could not find linked table

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.  
   
LVL 1
jrriAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

fabriciofonsecaCommented:
If you have any subforms in to this form, go to the subform properties and look for the foloowing properties:

source object
Link child fields
link master fields

Regards
jrriAuthor Commented:
fabriciofonseca,

Checked your suggestions, they are all set properly.

fabriciofonsecaCommented:
Try to create a new blank database and import all objects from the old one.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

jrriAuthor Commented:
Thanks for the suggestion, still no luck.
jrriAuthor Commented:
Upon further investigation we found we were unable to write directly to the SQL table.  We are re-submitting as a new question to provide more clarity.
jrriAuthor Commented:
didn't fix the problem but thanks for trying
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.