VB6 ADO Connection does not run a query

C

Cloe

Hi all.
I use vb6+ado 2.7

I tried con.execute (sql)

SQL= "UPDATE tblClubOperators SET
LoginName='a2',Password='b1',AccessLevel=1,CardSerialNumber='' WHERE
LoginName='a1'"

I had an error - syntax error in update

I went to access and executed this query with no problems.

Please advise.
TY
Guy
 
M

Michel Walsh

Hi,


*Maybe* using

CardSerialNumber=Null

instead of an empty string. You may also try

con.Execute sql, , adCmdText

instead of

con.Execute (sql)


Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem creating Transform query with ADO 0
Access 2003 Transform Queries?? 7
update query ODBC--call failed 3
round eror in 2003 and VB6 1
Calling Parameterized Query Using SQL Syntax 3
ADO question 15
Query to Filter by Dates, Using Form 7
VB6/MSAccess Query Problem 0

Top