Symptom
- When creating Crystal report against MS Access database through ODBC connection the following error occures:
Database Connector Error: '22007:[Microsoft][ODBC Microsoft Access Driver]Invalid datetime format on column number 3 (F3) [Database Vendor Code: 35 ]'
(The column number may be different)
Environment
-
SAP Crystal Reports 2008
-
SAP Crystal Reports 2011
-
SAP Crystal Reports 2013
-
SAP Crystal Reports 2016
- MS Access 2007
Reproducing the Issue
-
Create 32bit ODBC connection against a MS Access 2007 database
- Create a CR report against the connection
- Insert text field >> data is shown correctly
- Insert date time field >> error occures
- Open MS Excel
- Go to data >> connection wizard >> select the ODBC connection
- Observe the same error message
Cause
-
The error is happening at the ODBC driver level
- The date time field should have date time records only (05/06/2017 00:00:00), but it has records with wrong values such as:
- empty values
- date without time (05/06/2017)
- time only (00:00:00)
Resolution
-
Clean/repair the data
OR
- Set the field type to text in MS Access
Keywords
crysta, reports, odbc, access, ms, microsoft, db, database, date, time, datetime, field, wrong, records, incorrect, insufficient, , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016