|
 |
access_asp thread: error in update statement
Message #1 by "Patric Olsson" <patric.olsson@t...> on Wed, 27 Nov 2002 15:34:39
|
|
I get this error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
statement.
if i response.write the statement it shows:
update main set A = 'A', B = 'B', C = 'C', D = 'D', E = 'E', F = 'F', G
= 'G' where H = 'H'
The database has opend up, the table name is correct, all the cols name
are correct and the are all text.
NTFS rights are set to change for everyone.
I can get data without problem from the databse.
help me plz
/Patric
Message #2 by "Ken Schaefer" <ken@a...> on Thu, 28 Nov 2002 10:31:23 +1100
|
|
http://www.adopenstatic.com/faq/80040e14.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Patric Olsson" <patric.olsson@t...>
Subject: [access_asp] error in update statement
: I get this error
:
: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
: statement.
:
: if i response.write the statement it shows:
:
: update main set A = 'A', B = 'B', C = 'C', D = 'D', E = 'E', F = 'F', G
: = 'G' where H = 'H'
:
: The database has opend up, the table name is correct, all the cols name
: are correct and the are all text.
:
: NTFS rights are set to change for everyone.
: I can get data without problem from the databse.
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by "Larry Woods" <larry@l...> on Wed, 27 Nov 2002 20:10:27 -0700
|
|
This is an interesting one. I recreated the same UPDATE and mine
worked fine! The only potential "reserved" word is "main" and
according to MS documentation, "main" is not a reserved work in
2000/2002. Looks like there's somethin' else we don't know about
this...
Larry Woods
> -----Original Message-----
> From: Ken Schaefer [mailto:ken@a...]
> Sent: Wednesday, November 27, 2002 4:31 PM
> To: Access ASP
> Subject: [access_asp] Re: error in update statement
>
>
> http://www.adopenstatic.com/faq/80040e14.asp
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: "Patric Olsson" <patric.olsson@t...>
> Subject: [access_asp] error in update statement
>
>
> : I get this error
> :
> : Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> : [Microsoft][ODBC Microsoft Access Driver] Syntax
> error in UPDATE
> : statement.
> :
> : if i response.write the statement it shows:
> :
> : update main set A = 'A', B = 'B', C = 'C', D = 'D',
> E = 'E', F = 'F', G
> : = 'G' where H = 'H'
> :
> : The database has opend up, the table name is
> correct, all the cols name
> : are correct and the are all text.
> :
> : NTFS rights are set to change for everyone.
> : I can get data without problem from the databse.
> :
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
Message #4 by "Patric Olsson" <patric.olsson@t...> on Thu, 28 Nov 2002 10:30:22
|
|
Thanks Ken !
the "[]" made it work.
/Patric
> http://www.adopenstatic.com/faq/80040e14.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Patric Olsson" <patric.olsson@t...>
Subject: [access_asp] error in update statement
: I get this error
:
: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
: statement.
:
: if i response.write the statement it shows:
:
: update main set A = 'A', B = 'B', C = 'C', D = 'D', E = 'E', F = 'F', G
: = 'G' where H = 'H'
:
: The database has opend up, the table name is correct, all the cols name
: are correct and the are all text.
:
: NTFS rights are set to change for everyone.
: I can get data without problem from the databse.
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
