Access2013 help - auto fresh links

chally3

Board Regular
Joined
Mar 22, 2006
Messages
155
Good morning all,

Can anyone help please as I am a relative noive with Access 2013. I have created a database from various linked files and am wandering is there anyway to get the linked tables to refresh automatyically when the database when opened (Or even using a button/macro comobo of 'refresh all'


Thank you

Kind regards
Mark
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Yes, but this is an unusual issue. Are the links being broken? Or is there some sort of network lag? Is it an Access Runtime version issue?
If they are NOT changing (new ones added, old ones removed, network paths being altered) then you could create a table with two fields in each front end. One field is for the table name, the other for the path. The linking code can be run
1) automatically (not the best since there's no need to do this each time it opens IF there is no issue)
2) or by user click of a button
3) or if a simple test fails
at which point the code relinks the tables using the list in the front end. Obviously then, this table cannot be in a back end.
In case 2, it likely means that a user function has failed because of broken links. There'd be no warning until user action uncovers the fault.
In case 3, the reliability is only as good as the certainty that whichever table you probe as a test is (almost) guaranteed to have a broken link. If not, but some other table links are broken, you'd have to fall back to case 2.
More info is needed from you in order to write anything useful, or you could Google "MS Access VBA refresh table links" and see what you think.
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,988
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top