Dear reader,

Is there some one who knows how you can work in a Citrix server
configuration with client terminals (no pc's). To use the client terminal as
a local station to store information temporary and after the application is
closed the temporary storage is gone. Thanks for any help.

Kind regards,

Simon

"Simon van Beek" <SvanBeekNL (AT) hotmail (DOT) com> wrote

If you are talking about a drive on the terminal, check the client network
if the terminal supports it. Storing information used by the Access FE on
the terminal instead of the user's folder the the Citrix server will likely
be slower.

On Tue, 19 Oct 2010 15:38:41 +0200, "Simon van Beek"
<SvanBeekNL (AT) hotmail (DOT) com> wrote:

Generally, but not always, the users profile, such as %appdata%, or
home folder is used to store files such as the Access front end (FE)
database file. In your situation a temporary file of some sort.
This can be a significant problem if the file is on a file server
local to the user but on a WAN to the Citrix/Terminal Server (TS)

For example at one clients most of the users were on local PCs in
Alberta but some users were in Ontario. But the Citrix/TS servers
were in Alberta. So I had to ensure that the users in Ontario were
using a FE stored on a file server in Alberta rather than Ontario.
(So I updated the Auto FE Updater to create user specific folders on a
flie server physicall adjacent to the Citrix/TSs.)

The preferred solution is to use a user specific folder right on the
Citrix/Terminal Server. However some/many IT admins don't like this
approach. So you may have to settle for a user specific folder on a
file server which is on the same LAN as the Citrix/Terminal Server
(TS).

There is an API call you can use to determine the users Application
Data folder See the section mentioning CSIDL_APPDATA at
API: Retrieving a Special Folder's location
http://www.mvps.org/access/api/api0054.htm

As this is the "standard" folder to store such temporary data you will
need to discuss the requirements with the IT admins to see if this
suits and is either on the Citrix/TS or on the LAN.

Finally, depending on what you mean by temporary storage see the
TempTables.MDB page at my website which illustrates how to use a
temporary MDB in your app.
http://www.granite.ab.ca/access/temptables.htm

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/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/