Having trouble with Access database

[DirtyB]

Does everyone else always have obscure problems when trying to hit an access database from .asp pages?

I can connect to the database and run select queries and return them to recordsets. However, I can't run any insert queries. When I do a response.write of my query string, I paste it into Access and it works just fine, the same insert query just errors out from ASP pages with the following:
syntax error in INSERT INTO statement...

here's my line from a response.write(querystring)

INSERT INTO NewProjectRecords(Key) values(12);

it works fine if I paste it into Access, and I can run select queries. .?????? Any Ideas?????

 

[foxbox]

put a space between NewProjectRecords and (Key) ...

br
Gerard

 

[DirtyB]

thanks, but that didn't fix it, any other suggestions?

 

[onedayfly]

try ([key])
because 'key is a special word....

 

[link9]

cash the semicolon --

you don't need them to use the query in ASP.