Unanswered: Access 2002 to Pervasive.SQL 8 via ODBC
I'm trying to use Access to create a backend for an app running on Pervasive.SQL 8 (PSQL8). I can successfully link to all my PSQL8 tables. I can view and query any PSQL8 tables NOT containing date/time fields. However, I CANNOT view or query my primary table, as it contains date/time fields and produces the following error when opened...
ODBC call failed
[Pervasive][ODBC Client Interface]Invalid date, time or timestamp value. (#0)
I'm guessing the problem is a date/time formatting issue between PSQL8 and Access. However, I have been unable to resolve the issue or find anything meaningful on either the MS or Pervasive sites.