| Nikos Yannacopoulos 2005-05-20, 7:24 am |
| Julia,
> I have created one fron-end and one back-end application. Is it possible to
> keep them booth in a shared location and let the clients create a shortcut to
> the front-end?
Possible:Yes, good idea:*NO*! Each user should have their own, dedicated
copy of the FE, otherwise you're looking at database corruption. It may
not (and most likely will not) happen day one or week one, but it will
eventually, and when it starts it will happen all the time.
I suppose your concern is FE updates? If yes, have a look at:
http://www.granite.ab.ca/access/autofe.htm
for Tony Toews' great (free) utility to handle that. Alternatively, if
the FE is fairly small, you could even use a small batch file to always
copy the from the network folder to the local HDD and then launch the
local copy.
> How do I handle the linked tables?
Not sure what the question is here.
If it is "how do I change the links if I move the BE", then the answer
is Tools > Database Utilities > Linked Table Manager while in the FE.
If it is "what do I do for various locations of the FE" the answer is
nothing; as long as the BE stays in one place and the FE links point to
it correctly, they will continue to do so wherever you copy/move it
within the LAN.
HTH,
Nikos
|