Hi again, I'm having problems with an insert record page to insert records into a msaccess database via sql and dreamweaver mx.asp pages.
There are four date fields that can be entered (all not required), but it keep getting the
ERROR;Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
from my documentation there seems to be a known problem with msaccess and update/insert server behaviours....
Has anyone managed to overcome this issue, and if so, how ??
thanks for your help...That may be because of the Date format on the access database.
Try to insert the date in this format:
aaaa-mm-dd
______________
Paulo Gonalves|||thanks heaps...I actually got it sorted about 20 minutes before I read your reply...and you were right...I had the msaccess date formats set to an input mask that I don't think dreamweaver took a liking to...
cheers.
No comments:
Post a Comment