Update a date/time field through VB. net

[Johnkokk]

How do I update a date/time field in a Microsoft Access database using SQL ? I am using VB .net and up to now all my sql statements work fine. I have tried several variations of this statement but none work. They all give me a generic "Error in UPDATE statement" message.If i try any other column of my database, the UPDATE statement works fine.It only has a problem with the TIME field which is declared in the database as DATE/TIME. For instance the following will NOT work.

UPDATE tablename SET timecolumn='12:34' where id=82

[Johnkokk]

Never mind.I figured it out. I needed brackets for the time field. So it should be :

UPDATE tablename SET [time]='12:34' where id=80