Need help with Update Statement

[Tomfoolry]

FieldName, Type, Size

productid, Long Integer,
name, Text, 255
french_name, Text, 255
productcode, Text, 50
brief, Memo, 536870910
french_brief, Memo, 536870910
description, Memo, 536870910
french_description, Memo, 536870910
specs, Memo, 536870910
french_specs, Memo, 536870910
reviews, Memo, 536870910
french_reviews, Memo, 536870910
price, Curreny, 8
saleprice, Curreny, 8
rebateprice, Curreny, 8
deliveryprice, Curreny, 8
corporate, Curreny, 8
government, Curreny, 8
wholesale, Curreny, 8
VIP, Curreny, 8
employee, Curreny, 8
image, Text, 255
catcode, Integer, 4
type, Text, 10
notes, Memo, 536870910
french_notes, Memo, 536870910
featured, Boolean, 2
accessory, Boolean, 2
rates, Memo, 536870910
french_rates, Memo, 536870910
rebateinfo, Memo, 536870910
french_rebateinfo, Memo, 536870910

Qry = "Update products Set name='Cybiolink 2500',french_name='',productcode='',brief='The Cybiolink 2500 has all the great features of the Cybio 2000, with a new sleek look. It has a four-line display with Simultaneous Viewing of existing and incoming calls, One-touch Voice Mail and a 67-Name and 99-Number Memory, which makes keeping up-to-date and organized an easy chore. ',french_brief='',description='The Cybiolink 2500 has all the great features of the Cybio 2000, with a new sleek look. The Cybiolink 2500 has a four-line display with Simultaneous Viewing of existing and incoming calls, One-touch Voice Mail and a 67-Name and 99-Number Memory, which makes keeping up-to-date and organized an easy chore. ',french_description='',specs='more specs coming soon...',french_specs='',reviews='',french_reviews ='',price=80,saleprice=0,rebateprice=0,deliverypri ce=5,corporate=80,government=0,wholesale=80,VIP=80 ,employee=80,image='no_image',catcode=7,type='',no tes='dec6.02 - sale until dec 24',french_notes='',featured=0,accessory=0,rates=' ',french_rates='',rebateinfo='',french_rebateinfo= '' Where productid=493"

objRecConn.Execute(Qry)

-2147217900, Syntax error in UPDATE statement.

When this statement is cut and pasted into an update view in access it works fine, but not from ASP.

Can anyone tell me what the problem is.
Thanks, Lloyd Cormier

[skhanal]

I am not an expert in ASP, just throwing a dart, don't you need a ; at the end of the query?

[Tomfoolry]

I have never needed one before

[Tomfoolry]

I figured it out, and have to say that this is pretty damn stupid on Microsofts part.

The datebase i was working with is only an access database(Hope nobody minds me posting this question in an SQL Server forum) and the connection string was the problem. I was using PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=datebase then switched to Driver={Microsoft Access Driver (*.mdb)};DSN=;DBQ=database and everything works fine now. What the heck was that about.

Anyhow if anyone ever has that problem, you now have a solution.

Thanks, Lloyd Cormier