My SQL/ASP is a bit rusty, so it may be an obvious answer, but why do I get "Syntax error in INSERT INTO statement." with this query:
strSQL="INSERT INTO news (title,summary,article,author,date,time) VALUES('"&title&"','"&summary&"','"&article&"','"& username&"','"&date()&"','"&time()&"')"

where title, summary, article, and username are all short strings?

(strSQL resolves to the following)
INSERT INTO news (title,summary,article,author,date,time) VALUES('AH','AHGFHFG','asdsa','jtmerchant','4/11/2006','7:19:03 PM')

Ah, I figured it out- 2 of my field names are reserved words (date and time). To solve it I simply put brackets [] around the field names.
strSQL="INSERT INTO news (title,summary,article,author,[date],[time]) VALUES('"&title&"','"&summary&"','"&article&"','"& username&"','"&date()&"','"&time()&"')"