Hi,
i tryed to insert with the following sql syntax:
"INSERT INTO Mail(betreff,inhalt,timestamp) values('asdf','asdf',#2008-09-03 13:27#)"
but it doesnt work.
If i remove the timestamp (insert into mail(betreff,inhalt)...) it works.
What is wrong with the TimeStamp? Access says its a syntax error.
Regards,
Thomas
AlanPosted Sep 3, 2008, 5:57 AM
The problem is that timestamp is a reserved word in Access.
I'd try enclosing it in square brackets to have it treated as an ordinary identifier:
"INSERT INTO Mail(betreff,inhalt,[timestamp]) values('asdf','asdf',#2008-09-03 13:27#)"