Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access TempVars

Posted on 2016-07-31
4
Medium Priority
?
104 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
PatHartman earned 2000 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 58
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

721 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