MS-Access前端无法识别SQL Server的日期 [英] MS-Access front-end does not recognise dates from SQL Server

问题描述

我有一个具有Access前端的SQL Server 2008数据库。我的问题是Access不能识别SQL Server的日期，因为它们的格式不一样。

SQL Server的格式是 YYYY-MM- DD

访问格式为 DD-MM-YYYY

当日期显示在文本框中时，它显示为一个字符串（没有旁边的小日历图标）。

有没有办法我可以配置我的Access前端，以便它识别SQL Server的日期？

干杯。

解决方案

将日期存储在SQL Server中作为数据类型Date或Date2尝试将其更改为DateTime我将数据从SQL Server 2008R2链接到访问97时出现此问题，访问未将其视为日期并对其进行处理像文本

I have a SQL Server 2008 database with an Access front-end. My problem is that Access does not recognise SQL Server's dates as they are in a different format.

SQL Server-s format is YYYY-MM-DD
Access' format is DD-MM-YYYY

When the date is displayed in a text-box, it is displayed as a string (without the little calendar icon next to it).
Is there anyway I can configure my Access front-end so that it recognises SQL Server's dates?

Cheers.

解决方案

If you are storing the dates in SQL server as the data type "Date" or "Date2" try changing them to "DateTime" I had this problem linking data from SQL server 2008R2 to access 97, access did not see it as a date and treated it like text

这篇关于MS-Access前端无法识别SQL Server的日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！