Re: Access Front End Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Sash <Sash@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have an Access database that links to SQL Server. When I've done this in
the past, I've given each user their own Front End (Access Database). My
thought was that if 2 users opened the same form and tried to perform the
same event procedures, they'd get an error otherwise. I'm about to deploy my
latest creation through Citrix and was questioned about the aforementioned
method. Is my thinking way off??? I'd love to deploy this to their
intranet, but need it done quickly. Any and all advice is greaty
appreciated!!!!

Yes, as the others have posted each Citrix user must also get their
own FE.

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.

However you want to be very careful you understand where Citrix would
install the FE copy of the database. If you use the persons home
directory this may be on a server thousands of miles away. You
really want to ensure the FE is at least installed on the same LAN as
the BE. If the IT dept won't let you copy anything to the Citrix
system then copy the FE database file to a user specific folder on the
same server as the BE file.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/
.

Relevant Pages

  • Re: Two buildings: Citrix or synchronized file servers?
    ... We are running quite a lot of applications on citrix server farm(2 ... > database client to connect to a database in the main building. ... > use Outlook to access a mail server in the main building. ...
    (microsoft.public.win2000.setup_deployment)
  • Security warning: unsafe expressions are not blocked
    ... I am getting a Security warning: unsafe expressions are not blocked when ... users are trying to log into the Access 2003 database through the Citrix ... Server. ...
    (microsoft.public.access.security)
  • service pack 4 update
    ... I put the service pack 4 update on my Windows 2000 server ... access the database. ... Citrix is owned by Microsoft. ...
    (microsoft.public.win2000.security)
  • access 97 running in 2k3 server
    ... I am trying to move an access 97 database to a Windows 2003 server. ... Ultimately this database will be published through citrix, ... front end connected with an ODBC connection. ...
    (microsoft.public.windows.server.scripting)
  • move an access 97 database to a Windows 2003 server
    ... I am trying to move an access 97 database to a Windows 2003 server. ... Ultimately this database will be published through citrix, ... front end connected with an ODBC connection. ...
    (microsoft.public.access.conversion)