Multiuser conflicts 1

[tseaman]

I have an Access application which has split the database between a SQL Server backend and an Access GUI front-end. A number of public variables have been declared in a public module which are used as a way of passing data from one form to another. In a multiuser environment, particularly one implemented through Citrix, where each user does not have their own copy of the GUI on their PC, are different users really updating the same public variables, such that it is possible that the wrong value is going to be passed back to one user because the variable had in the mean time been changed by another user?

 

[psemianonymous]

You'll be fine, so long as you don't store this global information in tables. Each Citrix/Terminal Server user gets their own memory space, so they don't overlap.

You'll be fine.

 

[tseaman]

Thanks for the explanation.

 

[Kanga35]

Here with Citrix we had some performance problem when used with Thin client... the administrator eventually made it such that each user get an independant copy of the front end on the server at loggin onto the DB.