I am using "SQL Native Client 10.0" SQLNCLI10.dll 7/10/2008. It has worked well up to know. I am trying to access a table using MS Access 2003 using the odbc driver and I can link to other tables in the same data base. When I like to the one in question the values in the records are ether blank or #Deleted. If I do an import instead I get some of the data but fields that are varbinary come out looking more like Chines characters. I do not need the fields with the Chines characters.
Any idea how I can get to the data that I need. Is there some parameter that I can change in the ODBC driver?
Any help would be greatly appreciated.
Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]
- Proposed as answer by Dave PatrickMVP Friday, September 23, 2011 1:27 AM