Re: Access Front End Question
- From: "Tony Toews [MVP]" <ttoews@xxxxxxxxxxxxxxx>
- Date: Tue, 30 Jun 2009 20:25:38 -0600
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/
.
- Prev by Date: Re: Access Front End Question
- Next by Date: Show difference between 2 tables
- Previous by thread: Re: Access Front End Question
- Next by thread: Show difference between 2 tables
- Index(es):
Relevant Pages
|
