Attain to MS Access DATE filtering via ODBC

Business Central/NAV Developers Forum
1

Hi, I’m having problems in retrieving data from Attain to MS Access via ODBC when I put some filtering criteria on any date field. The ODBC driver simply doesn’t understand the date filter & returns an error. On the other hand, it works fine with MS Excel. Any one have any ideas, WHY & HOW can I fix this problem?

2

Hi, switch the “Identifiers”-Option in the “C/ODBC Options” to “All Exept Space” Bye KarlNapp

3

Thanks Hein, I solved the problem by uncheking “Commit Cache” and “Closing Date Support” in C/ODBC options. Identifiers is still set to “All Except DOT”! Bye Tariq