Access 2010 with linked AS400 tables trying to refresh link of table that is gone

I have a Access 2010 database with linked AS400 tables. When I open the Access database, it tries to refresh the links using tdf.refreshlink.  I changed the name of the AS400 table. I no longer see that AS400 table in Access as a linked table but the refresh VBA code seems to still be looking for it.   It gives me the error 3011 - The Microsoft Access database engine could not find the object 'tablename'. I have looked in the Mysysobjects table and there is still a row for this table. How can I stop the refresh code from looking for it? I can't modify the MySysObjects table so that is not an option.
Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
If the tables are linked via "external data", ...the ODBC refresh rate is set to 1500 seconds by default. (I think that works out to every 25 minutes...?)

But you can adjust it to whatever you like.
There are other settings as well, they are listed in the Access options:
Client Settings-->Advanced

But remember the higher the refresh rate the more resources Access must use to keep refreshing...

But I think the tables are refreshed every time you open them.  Just do a test to be sure.
Update a record in the AS400 ,then open Access a minute later and see if it is there...
Jeffrey CoachmanMIS LiasonCommented:
How are yo linking  the tables?
If the tables are linked into Access using the "External data" utility, they will be refreshed automatically...when the db opens.

I would only use tdf.refreshlink, if I had a distinct problem.

Try relinking the table (with the new name) and see what happens...

Lets see what other experts may post, in case I am not understanding something here...

LeLeBrownAuthor Commented:
I am linking using the external data ODBC connection. I removed the refresh code and it seems to be running ok now. So... if I have AS400 tables linked in Access, using the ODBC connection, these table links automatically get refreshed? These tables get updated daily with a AS400 script so I want to  be sure the Access db is getting the updated data.

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Jeffrey CoachmanMIS LiasonCommented:
<But remember the higher the refresh rate the more resources Access must use to keep refreshing...>
I should have said:
"But remember the Lower the refresh rate the more resources Access must use to keep refreshing..."

But I am sure you knew what I meant.


LeLeBrownAuthor Commented:
Jeffrey CoachmanMIS LiasonCommented:
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.