fastest way of distributing a split and secured database

  • Thread starter Thread starter jaworski_m
  • Start date Start date
J

jaworski_m

I have a split and secured Access database:

database_BE.mdb + workgroup file (network location)
database_FE.mdb (mde) - local copy for each user
shortcut (/wrkg ...)
where,
BE - back end
FE - front end

What is the most convenient way to distribute shortcut + database_FE to each
user?
The below described distribution ways seem to be either labour-consuming or
rather not very practical:
- instruct each user how to modify the path in shortcut to local copy of FE
- configure shortcut on each PC individually

I don't any Access developer extensions.

Is there any other way?

Thank you for hints.
 
jaworski_m said:
What is the most convenient way to distribute shortcut + database_FE to each
user?
The below described distribution ways seem to be either labour-consuming or
rather not very practical:
- instruct each user how to modify the path in shortcut to local copy of FE
- configure shortcut on each PC individually
Click to expand...

Setup the Auto FE Updater so it works on your system and creates a
shortcut. Copy that shortcut to the server and put it in the root of
a share and give it a meaningful name such as "Click here to install
the blah blah program." Tell the user to navigate Windows Explorer
to that server and share and to click on the short cut.

You might be able to email them a link to the above shortcut in an
email but I've never done that so don't know if that would work very
well.

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

In a Terminal Server or Citrix environment the Auto FE Updater now
supports creating a directory named after the user on a server. Given
a choice put the FE on the Citrix server to reduce network traffic and
to avoid having to load objects over the network which can be somewhat
sluggish.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top