Global Variables

[jaydy]

I am running an access program on two computers but only one of these computers have access in it, the other computer accesses the database through network sharing of files. i am also using global variables to track logging between users. I inserted a globalvariable currentuser in the module logger. everytime they login the current user changes. my question is if one computer changes the currentuser example, will this be overwritten by the other computer? will i be able to track two computers with one global variable? if not, how do i solve this?

 

[KenReay]

Hi

The Global variable is 'Global' within the Instance of Access, since you have two Instances running, you have no problem, I would point out howver that CurrentUser() is a function within Acecss which returns the Lgged in user id (that is Access user, as in Access security, not Windows or Network user), therefore it is probably not a good idea to have a variable (global or local), with the same name.

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK