VS2005 : - Run program with DB on multi-user Windows 7

[Ian Wong]

I have a program and install for multi-user logon in Windows 7.
The program has a DB created on Common Application Data Path by user A.
When user B is login and using the program to update the DB. Then logout.
When user A is login and using the program and cannot find the updated data
by user B.
Then I search the computer and find that one copy DB on user B's
virturalstore folder. Can I use the program code to check the DB on
virturalstore or on common data path? What can I check by program code?

 

[vanderghast]

You have to REQUERY recordsets/forms to see data added by others (even the
running code is another 'user' than the one in front of the keyboard). If
'others' only changed values form existing records, then you can use a
REFRESH instead of a requery. RECALC would recompute the formulas in your
forms (you cannot turn it 'automatically on' as it is the case with Excel,
you have to explicitly force a RECALC to occur). Note that a refresh makes a
recalc and a requery makes a refresh.


Me.Requery, in code, will requery the form, as well as closing it and
re-opening it.


Vanderghast, Access MVP

 

[Ian Wong]

I am using VB's database adapter to update the MDB. The operating system
automatical to create a MDB under the virturalstore folder when the user is
no right to update the original database.

 

[Tony Toews [MVP]]

I have a program and install for multi-user logon in Windows 7.
The program has a DB created on Common Application Data Path

Verify that Common Application Data Path can be updated by regular
users. That is can they both create and update .txt files using
Notepad.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/