i tried to insert data from a form using jet

now everythign wirked fine apart from it refusing to handle db fields with auto increment

my db lookes like this

id:auto increment
text:text
date:date


the sql looked like this

INSERT INTO table(text, date) VALUES('" & text.text & "', date())

resluting in a syntax error
i tried everything like:

INSERT INTO table(id,text, date) VALUES('','" & text.text & "', date())

always resulting in a syntax error so i deleted the id field in my db and the top sql worked ... can someone tell me how to handle auto-increment with jet???


thx