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