?
Solved

Installation of MDE and MDB in Vista

Posted on 2008-10-02
4
Medium Priority
?
557 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
3 Comments
 
LVL 58

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 58

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
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.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

621 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