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????