jonathanchye
Registered User.
- Local time
- Today, 18:45
- Joined
- Mar 8, 2011
- Messages
- 448
Hi,
I currently have a public module to track user names and logons etc. This works fine if only me open the DB.
I wonder what will happen after I split the DB and distribute the FE to each end users PC. Will the variable then be saved locally in this case? ie every user will have their own variables saved?
Will Option Compare Database be supported in multi user environments? TO further explain here is an example of how I declare my variables :
This is done under a module called "basVariableTracker"
I then call userID in forms and asign a value to them and then recall it later in other forms etc...
I plan to first split the DB I am implementing into BE/FE. Save the BE on the shared drive (server) and then ask the user to copy a FE to their own desktop and run the FE on their desktop. Will this work?
I currently have a public module to track user names and logons etc. This works fine if only me open the DB.
I wonder what will happen after I split the DB and distribute the FE to each end users PC. Will the variable then be saved locally in this case? ie every user will have their own variables saved?
Will Option Compare Database be supported in multi user environments? TO further explain here is an example of how I declare my variables :
Code:
Option Compare Database
Public userID As Long
I then call userID in forms and asign a value to them and then recall it later in other forms etc...
I plan to first split the DB I am implementing into BE/FE. Save the BE on the shared drive (server) and then ask the user to copy a FE to their own desktop and run the FE on their desktop. Will this work?