sharing variables or not

[JeroenNL]

Hi there,

Suppose I have 1 database that contains 1 VBA module with a public variable like this:

public myCode as string

Now 2 users open the database at the same time and change the value of the myCode variable. Will there be 2 seperate Access instances and will the users be able to work with the myCode variable seperately? Or are they in fact sharing the variable?

Bye,
Jeroen

A 3D editor project

http://www.delgine.com

 

[drctx]

it creates a seperate instance.

 

[JeroenNL]

Thanks. Figured as much, just wanted to make sure.

Bye,
Jeroen

A 3D editor project

http://www.delgine.com