Nicholson, Karen
cyx5 at cdc.gov
Mon Sep 27 07:19:03 CDT 2004
Interesting. The SQL backend structure can not be changed as it is proprietary. Yikes. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike & Doris Manning Sent: Monday, September 27, 2004 7:27 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Access/SQL Dates I ran into this problem when I used smalldatetime in the table as the data type instead of datetime. To be honest, I was in a hurry and didn't have time to figure out why it was happening. I just changed from smalldatetime to datetime and the problem went away. I've never used smalldatetime since then. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen Sent: Monday, September 27, 2004 6:33 AM To: accessd at databaseadvisors.com Subject: [AccessD] Access/SQL Dates I have an Access front-end and am querying an SQL backend. When putting in a select statement in the query, all is fine if I specify a date of say, less than today or <date()... However, if I try to specify a particular date, I get an sql overflow error. The syntaxes I have tried include: <#9/27/2004# <'9/27/2004' <'20040927'. Any clues? Thanks. Karen Nicholson National Laboratory Xerox Global Services -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com