inserting ms access date field

[icemonster]

so i'm trying to insert a record using VBA with my mysql back end but am getting an incorrect date value error, anyway to fix this? i am using the ADOBD connection.

 

[speakers_86]

Perhaps if you post your code, you will get some feedback. Also, what is the data type of the field in your backend?