Are public variables in shared database unique by instance?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple database in a shared network folder. The database has a
module with a public variable that is referenced and changed by user forms.

If multiple instances of the database are opened, will the value of the
public variable remain unique for each instance?

Thanks in advance,
Dan
 
Yes, public variables are stored only in memory on each
client machine, and each client has a unique instance.

(david)
 
Yes since each user runs a _different_ instance of Access. Users only share
data in Tables, not data stored in variables which only exist in memory.
 
Back
Top