I have a bunch of databases running on a SQL server 2008 instance. They're all set to the default Latin collation, and the server is set to UK English locale.
I have an access database using linked tables to the SQL server. The lcal PC is Windows 7 and also set to English UK locale.
However, the date fields in the SQL server tables are interpreted by Access as "text" type, not date. When I type a date into them in standard UK english format - dd-mm-yyyy, access accepts them but the SQL server rejects them because for some reason
it is wanting to store the data in the format yyyy-dd-mm.
I realise I'm no expert, this is probably something really simple and I'm probably being stupid, but can anyone shed any light on WTF i going on here and why, and how I fix it. I realise I could code in access forms something to force the date into
yyyy-dd-mm format and re-interpret it to English when I want to display it, but that's clunky and horrible.
Any ideas gratefully received. Thanks.
View Complete Post