Public variables in database with multiple users 1

[clapper62]

I have an Access database with multiple users which has public variables declared in a module. My question is if 1 user on 1 workstation changes the value of the variable is that value changed for any other users on different workstations?

"There is no pleasure in having nothing to do; the fun is having lots to do and not doing it.
." - Andrew Jackson

 

[lameid]

No.

All variables are scoped to the application instance, in this case on each machine. Even two separate instances on the same machine could have different variable values.

The same is true for it but you might look at the new Tempvars collection to store variables as those values perist even when cases where traditional variables are wiped (certain crashes).

The only data common among multiple instances is table data.

 

[clapper62]

ty I was hoping this was the case.

 

[vbajock]

To keep out of trouble with Globals just make sure you structure them around a private variable declared in module they reside in, for example

Option Explicit
Private sCatNo as string


Public Function SetCatalogNo(byval passStr as String)

sCatNo=passStr

End Function

Public Function GetCatalogNo() as String

GetCatalogNo=sCatNo

End Function


It will also make it easier to organize them into classes later if you decide to do so.