Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Installation of MDE and MDB in Vista

Posted on 2008-10-02
4
Medium Priority
?
554 Views
Last Modified: 2012-05-05
Hi everyone,

We use the Microsoft Access Developers toolkit for Access 2003 to create an installer for our access application.

The installer installs the two database files required to run, they are an MDE and an MDB.

They get installed to C:\Program Files\Our Application\

On Windows XP this is totally fine but on Vista it creates a copy of the database files each time we run which causes lots of issues because C:\Program Files on Vista is read only.

Where would be the best place to install the application on Vista. Or could we programmatically make our folder in Program Files Read/Write enabled.

Also, how could we detect that Vista is the operating system in Access VBA????
0
Comment
Question by:Milks
[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 56

Expert Comment

by:McKnife
ID: 22629411
"C:\Program Files on Vista is read only" - no, it ain't. But without the so called elevation, you cannot write into %program files% even when running as administrator. So elevate or alter the ntfs rights to users: modify.
0
 

Author Comment

by:Milks
ID: 22629536
Mcknife please explain what you mean by ekevate or alter NTFS rights.

Could you provide me with a documentation, or user guide on how to change this??
0
 
LVL 56

Accepted Solution

by:
McKnife earned 2000 total points
ID: 22629599
To elevate a program, rightclick its executable and select "run as administrator". [setups usually self-elevate, you see the "grey curtain" togther with the dialog "windows needs your permission to continue" - that's elevation].
NTFS-permissions can be altered by rightclicking the file/folder and selecting properties - security. The users group will need modify rights on that subfolder of c:\progfiles, I suppose.
There are commandline tools for both tasks. For elevation, see here: http://technet.microsoft.com/en-us/magazine/cc162321.aspx, for NTFS permissions: use icacls.exe (belongs to any vista installation).
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

636 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