Linked Table Manager

[ant1983]

Hi,

I am designing a db with a FE and BE for a my brother's company. They are
based in South Africa and i am in Qatar.

I have completed the db and now want to zip and send them this. The BE will
go on the server and FE copies on all the user's machines.

My questions are:

1 - If I link the FE to the BE on my PC in Qatar and email them the zipped
folder, would the FE and BE still be linked if they placed the BE on the
server and copies of the FE's on different machines or will the Link Table
Manager Box have to be tun again?
2 - Also, how does one (as a developer) normally deploy a db remotely.
Surely i cant ask this client to run the Linked Table Manager?
3 - Lastly, is there code that i can write and bind to a form that can Link
a FE to a BE? - e.g:

What i was thinking of doing is writing code and linking it to a form as such:

frmLinkTable
- cmdBrowse (This would open a 'Open File Dialog Box' and the user would
browse to where the BE is saved and select it and click OK which will place
the directory in the following field:
- txtFileName;
- cmdOK, (Once this is clicked the BE and FE link)
- cmdCancel,

Am i overcomplicating it - Im sure there's probably a straight forward
question like a simple macro to run the Link Table Manager...

Thanks!!

 

[Douglas J. Steele]

1. The only way the linkage would be correct is if all machines in question
are mapped the same way so that it's consistently, say, F:\Folder\File.mdb

2. I never use the Linked Table Manager, even for my own use. I always put
my own code into the application. I often distribute an INI file along with
the application, with the path to the server being in the INI file. If the
users can't figure out how to relink themselves, they can send me the INI
file (or I can give them instructions what to type into the INI file) and
the program uses that information to relink.

3. http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" is code
that can relink. (Don't forget to follow the instructions and download the
code from http://www.mvps.org/access/api/api0001.htm as well)

 

[Armen Stein]

1. The only way the linkage would be correct is if all machines in question
are mapped the same way so that it's consistently, say, F:\Folder\File.mdb

2. I never use the Linked Table Manager, even for my own use. I always put
my own code into the application. I often distribute an INI file along with
the application, with the path to the server being in the INI file. If the
users can't figure out how to relink themselves, they can send me the INI
file (or I can give them instructions what to type into the INI file) and
the program uses that information to relink.

3. http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" is code
that can relink. (Don't forget to follow the instructions and download the
code from http://www.mvps.org/access/api/api0001.htm as well)

Doug's right, an end user should never have to use Linked Table
Manager.

We have a free download for an automatic relinker at
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp. It
has a mode that silently relinks the BE if it is found in the same
folder as the FE. Otherwise it prompts the user for the location.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com