I'm using ado to add new records to an access database and get a type mismatch error. I'm also trying to add fields that are date and number types...<BR>help! How do I fix this?
Make sure that the data-types you're trying to add match the ones from the table, this can cause errors. Especially when adding string-values to integer-only database-fields
In addition, make sure to add true dates to a 'date-only' field, you can use strings, but make sure that they have the correct format.