ASP sql syntax error but MS access query ok

[ucbu]

Hi,
I wrote an ASP page using MS access 2000 on an ISS 5.0.

I got "Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement." at the execute line of the sql:

insert into att(aName,line1,line2,mobile,email, noidung,image, partner) values('abcd','abd','adf','adf','df','abcde ','images/personnel/',on)

When I copy & paste this query in ms access, the query work just fine. I can see the new added record.

Table attorney have aID as auto-number. aName, line1, line2, mobile, email, image as text (50)
noidung as memo
partner as yes/no

What's wrong with the query in ASP?

[ucbu]

Solved. I knew the problem must be something reserve word but did not check keywords for MS Jet. Turn out that 'image' is a reserved word for M$ jet. When I change it, the query works.