Ron Grabowski wrote:
The problem is not with updating date fields in Access. Did you check the format property of the Access Date/Time field? If the format is set to "Short Date" and you try to set the WHERE criteria parameter's value to DateTime.Now, the exception may occure even in SELECT statement. Try altering the format property to "General Date" or completely empty: (there should be small Access screen capture below) I'm developing a product, which supports several databases including MS Access and I'm beginning to use iBATIS on some modules. Ron, you're not completely alone with your Access problems :) Regards, Jarmo |
<<inline: moz-screenshot-1.jpg>>
