Solved

Installation of MDE and MDB in Vista

Posted on 2008-10-02
4
549 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
  • 2
4 Comments
 
LVL 54

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 54

Accepted Solution

by:
McKnife earned 500 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 Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

726 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