This problem gave me a whole bunch of hassle, so I thought I'd post my solution as it cost me a half day of browsing the ng's
If you're trying to execute an SQL query on SQL Server via MS Access/VBA/ADO/OLEDB that has a date criteria, e.g.
WHERE AND [table name].[date field]>=#03/04/2002# And...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.