By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,687 Members | 2,046 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,687 IT Pros & Developers. It's quick & easy.

update query in ms-access doesn't working

P: n/a

hi guys, my prblem is that I cannot update sql query against MS ACCESS
using C#. Everytime wen i do so, i got an exception (at runtime) as
'UPDATE syntax not correct'. I don find any error in my 'update'
syntax.

I can successfully run other dbase operations like insertion, deletion
& all.; except Updation.

But, i can successfully run the same update query in the 'sql query
tab' of MS ACCESS, and is executed successfully.

I'm using VS.NET 2005 & MS ACCESS 2003.

please help me...its urgent.

i'm including the code below :

************************************************** ***************

string provider = "Provider = Microsoft.Jet.OleDb.4.0; Data Source =
db1.mdb;";
string sql = "update Table1 set Password = 'modify' where ID =
'abhi'";

try
{
OleDbConnection oc = new OleDbConnection(provider);
OleDbCommand od = new OleDbCommand(sql, oc);
oc.Open();

od.ExecuteNonQuery();

oc.Close();
}
catch (Exception exp)
{
return exp.Message;
}

************************************************** ***************

My table contains two field : "ID" & "Password", both are of String
type.

************************************************** ***************

thanks in advance
Nov 24 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
I'm not sure, but perhaps it is the quotes in the string (mabye it is
looking for a double-quote)?

I doubt that your string is a constant like that, but rather, a string
that you concatenate together. In this case, you should use a parameterized
query, and let the provider handle the parameter formatting issues for you.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

<ab************@gmail.comwrote in message
news:61**********************************@a39g2000 pre.googlegroups.com...
>
hi guys, my prblem is that I cannot update sql query against MS ACCESS
using C#. Everytime wen i do so, i got an exception (at runtime) as
'UPDATE syntax not correct'. I don find any error in my 'update'
syntax.

I can successfully run other dbase operations like insertion, deletion
& all.; except Updation.

But, i can successfully run the same update query in the 'sql query
tab' of MS ACCESS, and is executed successfully.

I'm using VS.NET 2005 & MS ACCESS 2003.

please help me...its urgent.

i'm including the code below :

************************************************** ***************

string provider = "Provider = Microsoft.Jet.OleDb.4.0; Data Source =
db1.mdb;";
string sql = "update Table1 set Password = 'modify' where ID =
'abhi'";

try
{
OleDbConnection oc = new OleDbConnection(provider);
OleDbCommand od = new OleDbCommand(sql, oc);
oc.Open();

od.ExecuteNonQuery();

oc.Close();
}
catch (Exception exp)
{
return exp.Message;
}

************************************************** ***************

My table contains two field : "ID" & "Password", both are of String
type.

************************************************** ***************

thanks in advance
Nov 24 '07 #2

P: n/a
ab************@gmail.com wrote:
hi guys, my prblem is that I cannot update sql query against MS ACCESS
using C#. Everytime wen i do so, i got an exception (at runtime) as
'UPDATE syntax not correct'. I don find any error in my 'update'
syntax.

I can successfully run other dbase operations like insertion, deletion
& all.; except Updation.

But, i can successfully run the same update query in the 'sql query
tab' of MS ACCESS, and is executed successfully.
string provider = "Provider = Microsoft.Jet.OleDb.4.0; Data Source =
db1.mdb;";
string sql = "update Table1 set Password = 'modify' where ID =
'abhi'";
Maybe password is a reserved word.

Try:

string sql = "update Table1 set [Password] = 'modify' where ID = 'abhi'";

Arne

Nov 24 '07 #3

P: n/a
On 24 Nov, 16:57, Arne Vajhj <a...@vajhoej.dkwrote:
abhilashcas...@gmail.com wrote:
hi guys, my prblem is that I cannot update sql query against MS ACCESS
using C#. Everytime wen i do so, i got an exception (at runtime) as
'UPDATE syntax not correct'. I don find any error in my 'update'
syntax.
I can successfully run other dbase operations like insertion, deletion
& all.; except Updation.
But, i can successfully run the same update query in the 'sql query
tab' of MS ACCESS, and is executed successfully.
string provider = "Provider = Microsoft.Jet.OleDb.4.0; Data Source =
db1.mdb;";
string sql = "update Table1 set Password = 'modify' where ID =
'abhi'";

Maybe password is a reserved word.

Try:

string sql = "update Table1 set [Password] = 'modify' where ID = 'abhi'";

Arne
check if an @ might help... donno why but test string sql = @"update
Table1 set Password = 'modify' where ID = 'abhi'";
dont think password is reserved, but new to c#

//CY
Nov 25 '07 #4

P: n/a
ch*******@gmail.com wrote:
On 24 Nov, 16:57, Arne Vajhj <a...@vajhoej.dkwrote:
>abhilashcas...@gmail.com wrote:
>>hi guys, my prblem is that I cannot update sql query against MS ACCESS
using C#. Everytime wen i do so, i got an exception (at runtime) as
'UPDATE syntax not correct'. I don find any error in my 'update'
syntax.
I can successfully run other dbase operations like insertion, deletion
& all.; except Updation.
But, i can successfully run the same update query in the 'sql query
tab' of MS ACCESS, and is executed successfully.
string provider = "Provider = Microsoft.Jet.OleDb.4.0; Data Source =
db1.mdb;";
string sql = "update Table1 set Password = 'modify' where ID =
'abhi'";
Maybe password is a reserved word.

Try:

string sql = "update Table1 set [Password] = 'modify' where ID = 'abhi'";

check if an @ might help... donno why but test string sql = @"update
Table1 set Password = 'modify' where ID = 'abhi'";
The @ should not have any impact here - no \ characters.
dont think password is reserved
http://support.microsoft.com/kb/248738 claims it is.

Arne
Nov 25 '07 #5

P: n/a
>
dont think password is reserved

http://support.microsoft.com/kb/248738claims it is.

Arne- Dlj citerad text -

- Visa citerad text -
I stand corrected, was thinking just C#, not access

//CY

Nov 25 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.