Microsoft Access Database Property Connection string is read only?

Question

4.00/5 (1 vote)

See more:

My problem is exactly as the subject states. I am using Microsoft access database which I can add with no problems but once I go to add the data adapter for the table I wish to view information from I get this error "Property (name of database) ConnectionString is 'ReadOnly'... I am having problems when it comes to where to make the correction.

the line of code in question was created by the form designer:

VB

Settings1.Virus_Signature_DatabaseConnectionString = resources.GetString("Settings1.Virus_Signature_DatabaseConnectionString")

please help.

thanks in advance

[EDIT]Dale 2012 - 29 Jan '12[/EDIT]
Ok well I am unsure where in the code the connection string may be because I did not write the code, it was added by the form when I added it with the binding source and then with data source to create my data set which has no error until I go to add the data member. could you inform me of where to look or how exactly to change the read only property?

can anyone please elaborate on this for me a bit more?

[EDIT]Dale 2012 - 20 Feb '12[/EDIT]
The connection string was wrong entirely. For others that might have had the same problem the correct format of the connection string is:

SQL

"SELECT table FROM database WHERE table='" & "'"

Posted 28-Jan-12 15:34pm

Dale 2012

Updated 2-May-12 7:24am

Maciej Los

v3

Add a Solution

Comments

Be Yourself 29-Jan-12 0:02am

The connection string you are using might be read only. Kindly change the readonly property of the setting to no in order to make the updation in database.Otherwise the link you are using might not have access rights to change in database.

Dale 2012 29-Jan-12 0:19am

Ok well I am unsure where in the code the connection string may be because I did not write the code, it was added by the form when I added it with the binding source and then with data source to create my data set which has no error until I go to add the data member. could you inform me of where to look or how exactly to change the read only property?

Dale 2012 29-Jan-12 0:21am

F1 brings me to MSDN but it is of no help

Dale 2012 29-Jan-12 2:00am

can anyone please elaborate on this for me a bit more?

Dale 2012 20-Feb-12 3:31am

the connection string was wrong entirely.

for others that might have had the same problem the correct format of the connection string is

"SELECT table FROM database WHERE table='" & "'"

Dave Kreskowiak 2-May-12 15:01pm

NO, it's not. That's an SQL query string, not a connection string.

Maciej Los 2-May-12 13:27pm

Dale, please always use "Improve question" button to upgrade your question. If you have found solution, mark your question as "solved".

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)