I have an Access Front End that connects to a SQL Server database.
The front end has linked tables and it uses dsn-less types of links. The provider is SQL Server Native Client 10.0.

The are all running Access 2010 runtime.
It works fine on all computers except 2 machines that are running Windows 7 x64.

The following line causes a problem:
Select * From table where datefield1 = #MM/DD/YYYY# and datefield2 = #MM/DD/YYYY#

The Error I an getting is:
Conversion failed when converting date and/or time from character string.

Any ideas?
Thanks in advance to all who reply.