When install my application in PROGRAM FILES in vista I can`t add records to it cause its read only , but when I istall it somewhere else it works!!!!!!!!! what do I do?
this is my connection string and the database is in my application folder:
"Provider=Microsoft.ACE.OLEDB.12.0;DataSource=|DataDirectory|\\Database3.accdb"

yeah, Vista can be a real pain. the simple way per user is to just set the permissions on the folder via an administrator, but that wouldn't work in a deployment situation. What will most likely need to be done is have the program create a folder in the users documents that houses its databases. so they will be accessible. I would have it detect the version of windows that is running, if its vista, copy the database to the user folder, there after the user folder version. otherwise, continue to use is as you have already been.

Best of luck.