Using Tempvars in a multi-user environment

Question

This is actually a multi-tiered question concerning using Access in a networked environment: Preferably someone who has practical experience developing Access solutions for multiple-users (30+ concurrent users) in networked environments.

1. If  Access is on a Active Directory network share, when multiple users are accessing the same database are they running a distinct instance of the Access database at their local machine? And if so, are the environmental variables in their local database distinct from anyone else's?  For example: if I am dynamically setting the value of a Tempvar variable in the database, will the change in one persons database instance effect the Tempvar value in someone else's instance of the same database?
2. What is the difference between multiple users accessing the same database from a network share and  using a FE/BE design?

Answer 1

Re 1:

Yes.

Yes.

No.

Re 2:

It's the difference between not following best practices, and following them.

Answer 2

Thank you