none
Accessing SQL Server with ODBC from MS Access Error #Deleted

    Question

  • 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.

    Wednesday, September 21, 2011 10:03 PM

Answers

  • Thank you very much.  I found what I needed.  I created a pass-through query, with only the fields I needed.
    • Marked as answer by Andre99 Thursday, September 22, 2011 4:36 PM
    Thursday, September 22, 2011 4:36 PM

All replies