Database Access Porblem on Vista

[Billy]

My application uses MS Access Database. Installs Ok on Vista but a
permissions error is generated when the application tries to open the
database. How would I fix this.

Thanks in advance

[Chris Morgan]

Post by Billy
My application uses MS Access Database. Installs Ok on Vista but a
permissions error is generated when the application tries to open the
database. How would I fix this.

Vista is very strict about the locations of files which can be
read and written to.
I bet that your MDB file is somewhere in the Program Files folder.
The only location to which a standard user has write access is
the equivalent of C:\Documents and Settings\<username>.
(On Vista I think this is C:\Users\<username>).

You may have to use a combination of the following options:

1. Use your setup script to change the permissions on the
folder in which you install the MDB file to allow global
read/write access
2. Create a manifest with elevated admin rights for your app
3. Recode your app to store the MDB file in the permitted location
for Vista compatibility.

Btw you can test most of this on XP by running as a non-admin
user. If you have an NTFS hard disk you will find that you have
the same restrictions on writing to the C:\ drive.

cheers,

Chris

[n***@again.com]

Post by Chris Morgan
The only location to which a standard user has write access is
the equivalent of C:\Documents and Settings\<username>.
(On Vista I think this is C:\Users\<username>).

What a perfect way to identify the first place for hackers to start
looking - force users to store their credit card numbers and letters to
the bank in a known location.

[Todd Frankson]

Post by n***@again.com

Post by Chris Morgan
The only location to which a standard user has write access is
the equivalent of C:\Documents and Settings\<username>.
(On Vista I think this is C:\Users\<username>).

What a perfect way to identify the first place for hackers to start
looking - force users to store their credit card numbers and letters to
the bank in a known location.

Only a moron would store their info on a computer open to the web.

[Franz-Leo Chomse]

Post by Todd Frankson
Only a moron would store their info on a computer open to the web.

Vista needs updates and thus connection to the net.

Regards from Germany

Franz-Leo

[Todd Frankson]

Post by Franz-Leo Chomse

Post by Todd Frankson
Only a moron would store their info on a computer open to the web.

Vista needs updates and thus connection to the net.

And like I said, Only a moron would save their Credit card info on a
computer
connected to the net.

And no, it doesn't NEED updates. You can run it fine with no connection.