Hard?: Global Variant by User??

  • Thread starter Thread starter Jimmy Ray
  • Start date Start date
J

Jimmy Ray

Hi Everyone,

I don't know if this is possible, but this is what I need:

I need global variables limited by user (Kind of defeats
the purpose of the global variable, huh?).

More specifically, I have an front-end .mdb that is used
in two ways: (1) on local workstations and (2) on citrix
servers. For the local workstations, I don't have a
problem, obviously, because the global variables are
specific to their local .mdb used only by that one user.

However, since Citrix users share one .mdb, on occation,
one user changes the global variable that before another
user finishes using it thus threatening the integrity of
the data. If I could create variables that users could
use globally, but specifically to the user, I would be
all set.

Unfortunately, I am forced to use the global variables
because of the way that the Access db is integrated with
another db.

Thank you for any help or feed back. Take care,

Jim
 
If you are using a real Global Variable (like Dim strSomeVariable as String)
then you do not have a problem. Even though all of the Citrix users are
using the same copy of the database, they each get their very own instance
of the app. However if your "Global Variable" is a field in a table that is
in the local copy of the database (the front end) then you are gonna' have
to do a re-think and refactor your app as all of the Citrix users WILL be
looking at that same table.

Ron W
 
Jimmy Ray said:
Hi Everyone,

I don't know if this is possible, but this is what I need:

I need global variables limited by user (Kind of defeats
the purpose of the global variable, huh?).

More specifically, I have an front-end .mdb that is used
in two ways: (1) on local workstations and (2) on citrix
servers. For the local workstations, I don't have a
problem, obviously, because the global variables are
specific to their local .mdb used only by that one user.

However, since Citrix users share one .mdb, on occation,
one user changes the global variable that before another
user finishes using it thus threatening the integrity of
the data. If I could create variables that users could
use globally, but specifically to the user, I would be
all set.

Unfortunately, I am forced to use the global variables
because of the way that the Access db is integrated with
another db.

Thank you for any help or feed back. Take care,

Jim
Click to expand...

I haven't worked with Access databases on Citrix servers myself, but
what I've read about it says that, even in this setup, each user should
have his own copy of the front-end *on the server*. See this link:

http://www.granite.ab.ca/access/terminalserver.htm

If you do it that way, it seems to me you won't have this problem with
the global variables.
 
Jim,
On Citrix, place the "Master copy" of your front-end file in a folder that
all user can access. Then, create a batch file that is executed on login of
each user (put it in the Startup folder of "All Users" or similar). The
batch file should copy each users local front-end .mdb from the "Master
copy" every time they log in, assuring they are all working in a separate
but still up-to-date copy.

Global variables are not shared by different users of the same file (try
it!) so that should not cause a problem in your case. If you are referring
to tables in the front-end that are used to cache data or something, then -
yes, there would be a good chance of conflicts. In any case the Citrix
strategy above should take care of that all. Load balanced Citrix servers
require a little more work and you may want to figure out a way to script
new users setups. Talk with your Citrix admin, they might see this as an
exciting new project to think about.

Hope this helps,
Mattias Jonsson
 
Back
Top