Access DateTime Insert

Question

Hi i tryed to insert with the following sql syntax: INSERT INTO Mail(betreffinhalttimestamp) values('asdf''asdf'#2008-09-03 13:27#) but it doesnt work. If i remove the timestamp (insert into mail(betreffinhalt)...) it works. What is wrong with the TimeStamp? Access says its a syntax error. Regards Thomas

Alan · Answer

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(betreffinhalt[timestamp]) values('asdf''asdf'#2008-09-03 13:27#)