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.

Does anyone have any ideas?