Re: FE/BE question

Golfinray <Golfinray@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I am ready to split a database. I know the general rule is for the FE to be
loaded on each users computer. However, my question is, if all the users will
be using the exact same forms and reports and not creating their own, could
you put the BE and FE in separate folders on the same network drive and let
them create a shortcut to the FE? If you did that would two users be able to
enter data into the same form at the same time?

You could put the FE on the server so long as each user had their own
copy of the FE. However this isn't as efficient as putting a copy on
each users local hard drive.

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.

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/
.

Relevant Pages

  • Re: Database Corruption
    ... I specifically created the Auto FE Updater utility so that I could ... For more info on the errors or the Auto FE ... that would cause the corruptions. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: My 2007 is very slow, please help
    ... The below mentioned Auto FE Updater will help with some of your pain. ... I specifically created the Auto FE Updater utility so that I could ... Access Performance FAQ page at ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: Connecting two back end Databases
    ... while driving faster than most people on the highway insisted on ... I specifically created the Auto FE Updater utility so that I could ... For more info on the errors or the Auto FE ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: My 2007 is very slow, please help
    ... My FEs are not MDEs, ... The below mentioned Auto FE Updater will help with some of your pain. ... I specifically created the Auto FE Updater utility so that I could ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: Access 2000 with SQL Server - MultiUsers
    ... >which has ODBC links to two different databases on a SQL ... I specifically created the Auto FE Updater utility so that I could ... For more info on the errors or the Auto FE ... In a Terminal Server or Citrix environment the Auto FE Updater now ...
    (microsoft.public.access.externaldata)