Setting Up An Access Database On Terminal Server Or Citrix

[Wayne]

I currently have one of my databases running on Citrix. I supplied
the user with the database and their IT people set it up. It has been
running happily for years.

I have now been asked to supply 3 databases to another user who will
run them on Terminal Server. They want a fourth "Master" database
that will basically be a form with 3 buttons on it that will serve as
a central location from which to start the other 3 "Child" databases.

I have very little knowledge of the mechanics of setting the databases
up on Terminal Server and this will be left to their IT people,
similar to the Citrix database that I mentioned. Will I have a
problem pointing to the paths of the "Child" databases from the
"Master" database, given that each user will have their own frontend
copy in their profile on Terminal Server?

Would I be better steering away from the "Master" database idea?

[Rick Brandt]

Wayne wrote:

I currently have one of my databases running on Citrix. I supplied
the user with the database and their IT people set it up. It has been
running happily for years.

I have now been asked to supply 3 databases to another user who will
run them on Terminal Server. They want a fourth "Master" database
that will basically be a form with 3 buttons on it that will serve as
a central location from which to start the other 3 "Child" databases.

I have very little knowledge of the mechanics of setting the databases
up on Terminal Server and this will be left to their IT people,
similar to the Citrix database that I mentioned. Will I have a
problem pointing to the paths of the "Child" databases from the
"Master" database, given that each user will have their own frontend
copy in their profile on Terminal Server?

Would I be better steering away from the "Master" database idea?

Well given that the master database should also have a copy placed into each
user's profile folder the path to the child databases is simply the same
folder from which the master is running. Something that is easily determined
in code.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Wayne]

On Jun 15, 9:47*pm, "Rick Brandt" <[e-mail]:

Well given that the master database should also have a copy placed into each
user's profile folder the path to the child databases is simply the same
folder from which the master is running. Something that is easily determined
in code.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt * at * Hunter * dot * com- Hide quoted text -

Of course. I should have thought of that. Thanks Rick.