[Zope] can't store a date in Access database

[Micah Martin]

Hello,

 This is the error the is troubling me:

Error Type: sql.error
Error Value: ('37000', -3502, '[Microsoft][ODBC Microsoft Access Driver]
Syntax error in INSERT INTO statement.')

My SQL statement: 
insert in TableName (Date) values ("10/24/2001")

I have tried at least a dozen different date formats including the wierd '#'
delimiters.   Anyone solve this problem?

	Micah

----------------------------------------------------------------------------
--
Micah Martin
Software Engineer
Object Mentor, Inc.
micah@objectmentor.com
www.objectmentor.com, www.xprogramming.com
www.pairprogramming.com,  www.junit.org