Am using Access 2010 to link through ODBC to SQL data base.
Have successfully set up and tested ODBC connection and verified that access is successful
However when I use the ODBC connector to link to the tables (can view them all) when I attempt to look up the data on the table ... my display shows all data elements as deleted#.
My SQL Server ODBC Driver is Version 6.01.7600.16385
I am using Windows 7 Enterprise and Access 2010 to view the table content on a 64 bit Operating system using Intel 17 CPU with quad processors and 8 GB of memory.
Have installed SQL Server Management Studio and am able to see the data without any issues using identical login as I am using for Access.
This is happening with every table that I link to in the data base ... both big and small.
...
Go to the complete details ...