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?
 
fabriciofonsecaCommented:
Try to create a new blank database and import all objects from the old one.
0
 
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
0
 
jrriAuthor Commented:
fabriciofonseca,

Checked your suggestions, they are all set properly.

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
jrriAuthor Commented:
Thanks for the suggestion, still no luck.
0
 
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.
0
 
jrriAuthor Commented:
didn't fix the problem but thanks for trying
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.