Asp Sql Time Format

Working in VBScript ASP page with MSAccess Db. Well I'm darn embarrased for this to be my first post on here - you know when you've solved all the big stuff and then some tiny stupid little thing sends you flat opn your face ?

I want to put a time into my sql statement, like this :

INSERT INTO hoursTbl (opening,closing) VALUES ('09:15','17:35')

or

#09:15#,#17:35#

or

#9:15:00#,#17:35:00#

etc etc....

nearly all of them work if I run them in Access itself, but none are working in my ASP page. I get the standard 'syntax error in INSERT statement' error message

Is it a special syntax I need?