Exception while trying to update access database after creating a setup

Question

0.00/5 (No votes)

See more:

I have created a setup project for my application in c#.
The problem is that an error named: "System.Data.OleDb.OleDbException: Operation must use an updateable query." occurs while my application tries to insert a row in the access 2007 database.
the database is installed in the same folder where the .exe file is installed.

I have checked for the permissions to the database but found no place to change the permission programatically for the database.

Thank you in advance!

Posted 7-Sep-14 1:14am

Member 11040029

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2014-09-07T01:20:00

Solution 1

Simple: don't install data files in program folders.
Access to Program Files (and subfolders) is restricted to reduce the harm done by virus and similar applications.
Instead, store the Db in a sensible location: Where should I store my data?[^] should help you find somewhere more appropriate.

Posted 7-Sep-14 1:20am

OriginalGriff

Comments

Member 11040029 7-Sep-14 7:26am

Hey thnx! But please guide me on how to install the data file at other location since i am using a setup project in the c# for the first time. Guide me how to set a different installation path for the data file.

OriginalGriff 7-Sep-14 7:33am

How would I know? :laugh:
I have no idea at all which installer you are using, or how it works...

Member 11040029 7-Sep-14 7:42am

Its a Setup Project of visual studio

OriginalGriff 7-Sep-14 8:38am

So...right click the "File system on Target Machine" in the setup file list
Click "Add Special Folder"
Add "User's Application Data Folder"

Right click "User's Application Data Folder" in the setup file list, and the select "Add...File..." and add your database to there.