var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Access Front End SQL Server DB
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.
Thanks in advance to all who reply.