Invalid database object reference. (Error 3276)

[joel009]

Hi All,
I am trying to set up a conversion Access database that upon opening you select the BE database, it alters 3 tables and then runs some update queries.
I am having a problem with this error. I get it after I alter some tables in the BE database when it tries to run the update queries I get this error. If I open the queries first in design mode they run fine. Any ideas? Do I need to refresh my links after I alter the BE tables?

Thanks in advance.
Joel

Joel

 

[PHV]

Do I need to refresh my links after I alter the BE tables
I think so.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[joel009]

That did it!

Joel

 

[joel009]

FYI - To anyone concerned. I was trying to use Access queries to make updates to the data in the remote databases tables. I had to switch then to SQL and use Docmd.RunSQL to eliminate all the errors.

Can anyone explain why that works? I can run the queries if I open the linked tables first but to make it all work smoothly I changed all my Access queries to use the SQL statment with Docmd.RunSQL.

To make things more confusing, after I programatically refreshed the links to the remote db tables on my machine it worked fine with the queries but when I sent it to another user it bombed with the 3276 error still.

Joel