Solved

Access TempVars

Posted on 2016-07-31
4
49 Views
Last Modified: 2016-07-31
In a multi-user environment, with concurrent users, are the values of TempVars the same for all users, or can they be set for each individual user?

For example, if User A has their TempVars!UserID set to 2, if User B starts to use the database on another PC, will their TempVars!UserID also be 2, or can User A have it set to 2, and User B have it set to 1 at the same time?
0
Comment
Question by:rick_danger
  • 2
4 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 41736517
Assuming the users are NOT sharing a single FE, the answer is every user has his own set.  If they are sharing the same FE, you should change your method of distribution so that each user has his own separate copy of the FE.  A simple method is to distribute a shortcut that points to a .bat file on the server.  The batch file copies the production file to the user's C: drive and then opens it.  This method has the added benefit of eliminating any bloat issue you might have with the the FE.

If the users are all sharing the same FE, I'm not sure what would happen.  Access is loaded into memory on each PC but I'm not sure if tempVars are saved when their value is updated.  If the TempVar is saved back to the database, then you would have conflicts.  In any event - NEVER, EVER, for ANY reason share a FE.
0
 

Author Comment

by:rick_danger
ID: 41736520
Pat
They all have their own FE.

Thanks very much for your answer.
0
 

Author Closing Comment

by:rick_danger
ID: 41736522
Excellent answer, and very quick.
0
 
LVL 57
ID: 41736555
<<If the users are all sharing the same FE, I'm not sure what would happen. >>

 TempVars are an in-memory collection.   Users using the same FE would not see the same values.

Jim.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now