Link-relink FE/BE tables

[Junior]

I have a split DB -
FE is mde, secure with separate MDW
BE is mdb and not secure

When i zip updated mde and mdb to email to a user it seems the links are
lost.
As the FE is an mde, secure, with bypass key disabled. What's the
proper/best way/ anyway(tearing my hair out) to design the mde so that the
user can relink the FE-BE after unzipping files?

 

[Douglas J. Steele]

Check http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" for
sample code.

 

[Peter De Baets]

I have a split DB -
FE is mde, secure with separate MDW
BE is mdb and not secure

When i zip updated mde and mdb to email to a user it seems the links are
lost.
As the FE is an mde, secure, with bypass key disabled. What's the
proper/best way/ anyway(tearing my hair out) to design the mde so that the
user can relink the FE-BE after unzipping files?

Our freeware TableLinker utility might help:
http://www.peterssoftware.com/tlk.htm

With it, you can easily change your table links from your environment to
your user's environment. A function is provided to help you do
this. Here's an example (from the readme.txt file):

tlk_ChangeDatabasePath "C:\My Production Folder\", "C:\My Testing Folder\"

Hope this helps,