Access 2003 on terminal server (Citrix)

[VinTom]

I am new to Access 2003. I developed a small application that is split into
front and back end for multi user environment. This scenario works fine but
now the requirements have changed and I have deployed it to a Terminal server
(Citrix) for multiple users. When the first user logs in it works perfect. As
soon as the second user tries to open the application it shows the following
message:

"You do not have exclusive access to the database at this time. If you
proceed to make changes, you may not be able to save them later".

I have checked the permission of the database, it is set to open in shared
mode. The front end and back end are in the same folder. There are no group
settings.

I can not figure out the problem. I would appreciate if someone could direct
me in the right directions.

Thanks.

 

[Tony Toews [MVP]]

I am new to Access 2003. I developed a small application that is split into
front and back end for multi user environment. This scenario works fine but
now the requirements have changed and I have deployed it to a Terminal server
(Citrix) for multiple users. When the first user logs in it works perfect. As
soon as the second user tries to open the application it shows the following
message:

Even on Terminal Server/Citrix each person must have their own copy of
the FE MDB/MDE. They can't share one copy amongst them.

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/

 

[VinTom]

I appreciate the quick response. Is there a way to open the same Front end
multiple times, for multiple users simultaneously?

 

[Douglas J. Steele]

It's not recommended. It increases the risk of corrupting the database
significantly.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

 

[Tony Toews [MVP]]

I appreciate the quick response. Is there a way to open the same Front end
multiple times, for multiple users simultaneously?

No. That's sharing the FE. You really, really don't want to do that.
However you can easily automate the process of distributing a new FE
to each user.

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
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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[John W. Vinson]

I can not figure out the problem. I would appreciate if someone could direct
me in the right directions.

Tony and Douglas are the real experts in frontend/backend issues, and I
absolutely agree: don't share the frontend.

What you *can* do is give each user their own private folder on the
Citrix/Server machine (or another machine on the same fast, stable LAN).
They'd each have a copy of the frontend in their folder, and use Citrix to
open their own folder to run their own copy.

John W. Vinson [MVP]

 

[VinTom]

Thank you everyone for the response. I will try to find another way of
deploying it.