I have a problem with Navision ODBC. With Attain 3.10, I have installed Navision ODBC and I use Access to see Navision data, but when I import or link Navision table e in my table there is e date field that is empty (0D) in Access I see 01/01/1753. Please, you know if it’s an ODBC error or an Access error and if I can do something to resolve this problmem? Thank you very much.
Hi David, When you import or link the Navision table in Access or even access throgh ODBC, it’s takes by default 01/01/1753 for 0D(undefined date in Navision).You can write a query to update those date with blank in Access database.