<div>
How are you applying the filters?<br />
<br />
What do you mean by &quot;not able to apply filters&quot;? Do you get an error? Or do you get data, but not the data you expect?
</div>


<div>
The Data Type in the SQL Database is &quot;smalldatetime&quot; so the error message does not make sense when it talks about a character string.<br />
<br />
Here is the error message:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/12_w50/1052821/snip_20151210115922.jpg" target="_blank" title="Error message after right-clicking an item in the date column and selecting the date filter. (264 KB)"><img alt="Error message after right-clicking an item in the date column and selecting the date filter." class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/12_w50/800_1052821/snip_20151210115922.jpg" /></a>
</div>


Error message after right-clicking an item in the date column and selecting the date filter.

snip_20151210115922.jpg

<div>
Open the linked table in design view (Access will complain, but will allow you to do it). What Datatype is Access reporting for the column?
</div>


<div>
What SQL Server driver are you using for your connection string?<br />
<br />
Try the &quot;SQL Server Native Client 11.0&quot; if you are using SQL Server 2008
</div>


<div>
We are using the MSDE 2000 SQL (Free version).<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/12_w50/1052841/snip_20151210122740.jpg" target="_blank" title="ODBC Configuration (94 KB)"><img alt="ODBC Configuration" class="file-block lazyload" style="max-width: 563px;" data-src="https://filedb.experts-exchange.com/incoming/2015/12_w50/1052841/snip_20151210122740.jpg" /></a>
</div>


snip_20151210122740.jpg

<div>
Well, everyone got quiet when after I posted my last message about SQL 2000. &nbsp;I know, I know. &nbsp;I've been trying to get my boss to upgrade our systems.<br />
<br />
Is there a chance if I download the new drivers that they will properly interface with the SQL engine? &nbsp;I'm willing to give it a try. &nbsp;But, I don't want to do that if there's no chance it will work or, more importantly, if it will corrupt something to the point of making things worse.
</div>


<div>
<div class="content wysiwyg-content">
We are using Access 2007 as an interface to a SQL Database via ODBC connections. &nbsp;We have observed we are not able to apply filters to Date/Time columns in the tables. &nbsp;The sort works fine...just not filtering. &nbsp;A query that selects a date range works correctly as well.<br />
<br />
These same tables filtered just fine with Access 2000.<br />
<br />
Any ideas?
</div>
</div>


We are using Access 2007 as an interface to a SQL Database via ODBC connections.  We have observed we are not able to apply filters to Date/Time columns in the tables.  The sort works fine...just not filtering.  A query that selects a date range works correctly as well.

These same tables filtered just fine with Access 2000.

Any ideas?

Access 2007 ODBC Date/Time filtering

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.