Relink tables stored on Network Drive on Opening

[jdawg_1989]

Hi,

I am running Access 2010.

I have a database that serves as a backend stored on a network drive which can be quite slow.

The problem I have is that everytime I open the front end database (stored on my computer) I have to open the Linked Tabled manager to refresh them.

Is there any code that I can use to automatically do this for me on opening the front end DB? I currently have and AutoExec macro to open a form on opening.

Thanks in advance,

 

[Mr Smin]

What happens if you don't refresh?

I find that problems arise if the networked drive is not mapped in Windows *before* launching the front end application. This could be a bigger problem with your slow networked drive.

In such cases I could refresh the linked tables but closing and re-opening the application is simpler.

 

[jdawg_1989]

The problem I have is that the form that opens with the database is a split form.

In the split form a have a field with an embedded macro that will open another form based on condition ="[ID]=" & Nz([ID],0)

If I don't go into the Linked Table manager i get a #NAME? error in that field.

Closing and reopening doesn't help.

 

[jdawg_1989]

For anyone who is interested, I have managed to find a solution for this....

I've used the code on this website: http://access.mvps.org/access/tables/tbl0009.htm

and then in the AutoExec Macro I've added RunCode function and fRefreshLinks() to call the function.

This seems to sove my problem.

Thanks All.