Relinking Tables On Startup

[1eye1vision]

Does anyone have any db's that show how to relink tables automatically on start up and also remove the links on shutdown, i've been searching everywhere on the net and can't seem to find anything decent, any help would be appreciated.

Thanks in advance.

 

[trucktime]

Relink tables

Perhaps this link helps.

http://www.rogersaccesslibrary.com/download3.asp?SampleName=RelinkOnOpen.mdb

Good Luck

 

[Pat Hartman]

Relinking on startup will be time consuming. Why not just leave the tables linked?

 

[RuralGuy]

Here's another link: Reconnect Attached tables on Start-up

 

[1eye1vision]

what if it moves

Ok i've read the link that RG, posted, but they have to be in the same directory, what if someone moves the BE, is there a way to then prompt the user for a new location, and store this location in the DB.

As for the post by Pat, the reason for not keeping the BE linked is so that the BE can stay on a Server and only the FE used.

 

[Pat Hartman]

As for the post by Pat, the reason for not keeping the BE linked is so that the BE can stay on a Server and only the FE used.

Having the tables linked permanently doesn't add any overhead. In fact it saves overhead. There's a lot of work that happens behind the scenes when tables are linked.

The links aren't "active" unless you actually have a table or query open.

If you are worried about the back end moving, check the link of one table. If it is bad, pop up your relink dialog otherwise, don't do anything.