auto refresh link table

  • Thread starter Thread starter xswzaq
  • Start date Start date
X

xswzaq

Hello,
Everytime when I open a access I need to go to Data -> Databse Utilities - >
Refresh Table Manager. Then I select all table to refresh. Is there a way
to make it auto refresh when I the access file?
Any help would be greatly appreciate.
Thank You
 
Why in the world would you have to relink the tables everytime you open your
database? Once place on your computer/server, you should need only set the
links once and then use it.

Any ways, I would suggest you take a look at

http://www.mvps.org/access/tables/tbl0009.htm

Also worth checking out

http://www.rogersaccesslibrary.com/download3.asp?SampleName=RelinkOnOpen.mdb
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.
 
I refresh it because if I don't, I will get ODBC -- run time failed.
Security issues or something I don't know why.
 
Warning!

this Chris guy is not credible.
He does not know the basics of MS Access.

Linked tables is no longer the reccomended way of working with Access.

It is reccomended to upsize to SQL Server and use ADP.

Anything else is a waste of time and resources.

-Aaron
 
For any who've somehow managed to avoid him to this point, Aaron Kempf is a
known troll who has been banned from Microsoft servers in the past, but has
apparently made his way back. He's the one who should be ignored.



Rob
 
Back
Top