where to put the front end in a split database

[Paul James]

I have a databases on our network server that's being used by several users
simultaneously. I would like to split it into a front end and back end, and
I'm wondering if I'm better off keeping the front end on the network server,
or whether it would be better to install the front end on all user's
desktops. Can anyone tell me which way would be better from the standpoint
of:

1. performance, and
2. file integrity (protection from corruption).

Thank you in advance.

Paul

 

[Tony Toews]

I have a databases on our network server that's being used by several users
simultaneously. I would like to split it into a front end and back end, and
I'm wondering if I'm better off keeping the front end on the network server,
or whether it would be better to install the front end on all user's
desktops. Can anyone tell me which way would be better from the standpoint
of:

1. performance, and

Putting the FE on each users PC would be slightly better.

2. file integrity (protection from corruption).

The key is to give each user their own copy of the FE. Whether it
resides on the server or the workstation doesn't matter as far as
corruption goes.

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 utillity 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

 

[Paul James]

Thanks for the info, Tony.

I'll take a look at the the db front end management utility on your web
site.

Have a nice weekend.