Need help with this simple sql statement
am 01.05.2005 10:54:45 von jillI am trying to store the current date to an ms access database on my server.
I set it up with a dsnless connection.
Here is the statement:
Insert Into employees(timestamp) Values ('" & date() & "')"
the timestamp field is of type date/time in the ms access database.
I get an error saying the insert statement is invalid. Cannot get you the
exact error, my server is down.
But it seems that the syntax is correct.
Please advise
thanks