Re: Date Format between Informix, Access 95 and ODBC drive

Yes Check the date format you have defined both at the client and server end. It looks pretty much like the date is being treated as mm/dd/yy[yy] somewhere along the line. That explains why it refuses entries > 12. The default format for dates with informix is mm/dd/yyyy. You need to set DBDATE=dd/mm/yyyy in order to change this. This should be done on the client side in IConnect (assuming you are using IConnect with the intersolv driver). Mark MarkDenham@aol.com (home) Denham.M@amstr.com (work)