Understanding workspaces in multi-user environment

[Taylor]

I'm looking to understand how variables behave in a multi-
user environment.

Specifically, I want to know if variables are unique to a
session - user. I assume so since I believe they are part
of the workspace object.

Next question is ... is a new workspace object created
when another user opens the same database? If so, how is
it named.

What I want to do is set defaults for each user such as
company if I have multiple companies in the same database.

Thanks

tlw

[Larry Linson]

This should make no difference, because you should never
have multiple users opening the same "front-end" database
because of the risk of corruption. The front-end should
reside on each users machine, linked to tables in the shared
back-end in a multiuser environment.

Shared "things" (but not variables) are a potential hazard
when multiple users open the same front-end (queries, forms,
reports, macros, and modules) -- things that may be written
to files, even temporary files, in the database.

"Taylor" <taylor_...@eaglenorthamerica.com> wrote in
message news:346201c243ab$fefd31b0$9ae62ecf@tkmsftngxa02...