Using pound sign as date delimiter

[EddieN1]

When I use ADODB in VBA to query an Access table for a date, I use syntax such as SELECT * FROM CUST WHERE CREATE_DATE > #01/01/2010#... This works fine when I'm querying an Access Database. However, when I try to use this syntax to query a table on SQL Server 2008 R2, it returns a syntax error. When I remove the pound signs, it works fine. The problem is that I need the same code to run against either database. Is there a setting on SQL Server that I can set to make is accept the pound sign delimiter convention? Thanks, Eddie

[June7]

Never used SQL Server but I doubt it. Probably need to have code that will structure the SQL statement to use appropriate syntax conditional on the target table.