I'm converting an Access project (adp) over to a linked table (accdb) front end with an ODBC connection to the SQL Server data and am having problems opening reports that have date criteria in their WHERE clause.
I've tried the following syntax in the WHERE clause:
ReportDate > #dd/mm/yyyy#
ReportDate > #yyyy/mm/dd#
ReportDate > #yyyy-mm-dd#
All three formats work on my development pc, but when I compile it and try to open the reports on a users workstation I get the following error for all three formats:
ODBC--call failed.
[Microsoft][SQL Native Client][SQL Server]Conversion failed when converting datetime from character string.(#241)
I'm using Access 2007 on Windows 7, connecting to SQL Server 2005.
Any ideas what the problem might be?
Matt
I've tried the following syntax in the WHERE clause:
ReportDate > #dd/mm/yyyy#
ReportDate > #yyyy/mm/dd#
ReportDate > #yyyy-mm-dd#
All three formats work on my development pc, but when I compile it and try to open the reports on a users workstation I get the following error for all three formats:
ODBC--call failed.
[Microsoft][SQL Native Client][SQL Server]Conversion failed when converting datetime from character string.(#241)
I'm using Access 2007 on Windows 7, connecting to SQL Server 2005.
Any ideas what the problem might be?
Matt