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

My advice would be to NEVER allow more than one person to enter any specific
front end at a time. Even if the front ends are located on a server, you are
better off having FileA for userA, FileB for userB, etc, even if FileA and
FileB are the exact same thing.

You're assumtion that errors may occur otherwise is correct. Corruption is
a problem here as well. I'd say your thinking is exactly on track with what
it should be.

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)



"Sash" 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!!!!

On Tue, 30 Jun 2009 10:23:01 -0700, Sash <(E-Mail Removed)>
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!!!!

Some of my clients use Citrix in this way. Each user is given their own
private folder on the Citrix server, and the frontend .mde file is copied into
that folder, so each user indeed has their own copy (ON THE SERVER, not on the
Citrix client, which is just acting as a dumb terminal).
--

John W. Vinson [MVP]

Sash <(E-Mail Removed)> 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/