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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top