Very very strange problem

B

Bilbo

Hi
I'm using Access 2003 as a front end to SQL server 2000. Yesterday many of
the dates I save (but not all) started being stored in American (rather than
English) date format. I've wracked my brains to try to work out what
happened and why but can't. I don't think any software changed. Most of my
systems have Windows XP pro and 1 has Vista but it's the same on them all.
Does anyone have any ideas or could point me inthe right direction? Thanks
and regards
 
D

Douglas J. Steele

Are you using SQL against linked tables, or are you using pass-through
queries?

If SQL against linked tables, Access will always try to use mm/dd/yyyy
format even if your regional settings are set to something else. It's only
when the date cannot be interpretted as mm/dd/yyyy (i.e.: days of 13 or
greater) that Access will treat the dates as dd/mm/yyyy. You're best off use
yyyy-mm-dd so that there's no confusion.

If you're using pass-through queries, how the date is interpretted is
controlled by a setting in SQL Server.
 
Top