Solved

Access TempVars

Posted on 2016-07-31
4
79 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 38

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 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
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…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

617 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