Installation of MDE and MDB in Vista

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????
MilksAsked:
Who is Participating?
 
McKnifeCommented:
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
 
McKnifeCommented:
"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
 
MilksAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.