Solved

Windows 7 uac virtualstore is not playing nicely with my front end database.

Posted on 2010-09-20
7
973 Views
Last Modified: 2012-08-13
my logon script currently
   copies \\server\frontEnd.mdb   to c:\program files\myFrontEnds\*.*
   copies  \\server\frontEndShortCut.lnk  to %ALLUSERSPROFILE%\desktop\*.*

On XP this worked fine. The user clicks on frontEndShortCut.lnk and they  get their own private copy of the front end.  

On Windows 7 with user account control (uac) disabled, this also worked fine.

But, I decided to turn UAC on, and things have gotton messy.  
When the user clicks on DesktopShortcut, the thing that actually gets opened is
C:\Users\rberke\AppData\Local\VirtualStore\Program Files\myFrontEnds\frontend.mdb.

So, I am thinking of simply changing my logon script so
it copies \\server\frontEnd.mdb   to c:\myFrontEnds\*.*

Does anybody think this is a bad idea?  For instance with UAC enabled, how can I make the login script cannot run an MD c:\myfrontends and then assign user full control.

This is getting to be more complicated than I want.

Does anybody have a nice example of a login script that:
1. works under windows 7
2. works under xp
3. automatically installs a front end database without manual intervention.
4. does not require UAC to be diasabled

For instance, I previously ran into other problems (reported in http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/Windows_7/Q_26473654.html)

0
Comment
Question by:rberke
  • 3
  • 2
  • 2
7 Comments
 
LVL 84
ID: 33720889
The root drive is protected on Windows7 machines, so you'd be no better off than you were before. You should instead copy them to one of the Data folders.

This is for Vista, but the same caveats apply to Win7:
http://msdn.microsoft.com/en-us/library/bb530410.aspx

0
 
LVL 90

Accepted Solution

by:
John Hurst earned 250 total points
ID: 33720934
You have lots of questions and I cannot answer all of them.

First, with UAC on, you cannot readily copy to Program Files (which is what you are seeing).

I would consider moving your data bases to a more benign location and your idea of c:\myFrontEnds is a decent idea. I have three such main root folders for thousands of documents organized within hundreds of folders. I sync between laptop and desktop (both Windows 7) with SyncBack Pro and it is painless and error-free.  This is with UAC on.

Also look at what NET SHARE does. I did a NET SHARE on my desktop and that facilitates back and forth copying (synchronization).

So:
1. Works with Windows 7.
2. Should work with XP.
3. Don't know - you would have to try.
4. UAC does not have to be disabled.

... Thinkpads_User
0
 
LVL 5

Author Comment

by:rberke
ID: 33726930
I moved it up to c:\myFrontEnds, and my folder security problems went away.  (I don't know why lsmConsulting thought they wouldn't, he is usually gives good advice.)

There is another UAC problem causing the net time  %logonserver% /set /yes   to give an access denied, but that is not a big deal.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 90

Expert Comment

by:John Hurst
ID: 33726983
Thank you, and thanks for the update. Good luck going forward. ... Thinkpads_User
0
 
LVL 84
ID: 33727175
Root drives are protected in Vista and Win7, but of course you can change permissions/restrictions as needed.

Proper application deployment techniques in Vista forward suggest that you install Programs to the Program Files section (this is a WRITE ONLY section) and that you install Data files to one of the Data folders (depending on how much access is needed, and by whom). If your FE needs to write to local tables, or you store data directly in the FE, then you'll need to move it to the Data folders section.

You can store your apps on the root drive, but don't be surprised when a Win7 update comes out and breaks this. UAC is not going away, and it's only going to get more restrictive. The root drive was NEVER intended as a storage location for user-run programs. That's what Program Files are for (or the Data folders, depending).
0
 
LVL 5

Author Comment

by:rberke
ID: 33728037
LSMConsulting:

As far as I know MS Access always opens MDBs for update, even if they don't modify their own tables.

I have opened up another question to deal with this subject specifically.  

If you want some points, we can continue the discussion here.

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/Windows_7/Q_26489270.html
0
 
LVL 84
ID: 33730550
<As far as I know MS Access always opens MDBs for update, even if they don't modify their own tables.>

I'm not aware of this, but you may be correct. The issue occurs when you actually attempt to WRITE the file - merely being able to do so shouldn't trigger any isuses.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

758 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now