Solved

Access TempVars

Posted on 2016-07-31
4
57 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 35

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

770 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