Member Avatar for ebiemami

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"

  • 2 Contributors
  • 1 Reply
  • 75 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Diamonddrake
Member Avatar for Diamonddrake

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.