Access 2007 ODBC Date Format

D

Dominic Batty

Hi,
We have a Pervasive SQL database with a number of tables linked into
Microsoft Access 2007 using Pervasive's standard ODBC driver.

We have a number of tables where some columns are being displayed as
YYYY-MM-DD whilst others on the same table are being display as DD/MM/YYYY
(which is what the regional settings are set to).

In Access 2003 the same table, linked through the same DSN displays all
dates as DD/MM/YY on the record.

Does anyone know if there might be a bug in Access 2007 where dates are
displayed in different formats for some reason.

Thanks in advance. Dominic Batty.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing a date entry format of dd/mm/yyyy 1
Publisher is filling blank lines with data 2
Date format when exporting to Excel 3
Date Format Incorrect on Export 1
Date format problem 1
Mail merge word-access and date format 3
Stumped By Dates 4
Outlook 2007 Date Format in Appointments in To-Do Bar 0

Top