N
Nate Scott
Using Microsoft Access (2003 and 2007) to link to tables on a SQL 2005 SP2
server is working most of the time. On some particular tables (MS Dynamics
AX database) the results of the linked table for all rows and columns is
#Deleted. It has the correct record count and importing the data or using a
pass-through SQL query will show the data correctly, it's only the linked
table that has this issue. We've tried both "SQL Server" and "SQL Native
Client" ODBC driver connections with the same results.
I've seen reference to this in KB articles that mention an upgrade to the
MDAC components but we're on the latest version already. Also seen reference
to Unique indexes with null values - not the case here. The table in
question is a simple address table with 52 columns, three indexes (one
unique), and works perfectly fine in the Dynamics AX environment or through
SQL Server Management Studio. It only seems to be Access that has this issue.
Help is appreciated.
Nate
server is working most of the time. On some particular tables (MS Dynamics
AX database) the results of the linked table for all rows and columns is
#Deleted. It has the correct record count and importing the data or using a
pass-through SQL query will show the data correctly, it's only the linked
table that has this issue. We've tried both "SQL Server" and "SQL Native
Client" ODBC driver connections with the same results.
I've seen reference to this in KB articles that mention an upgrade to the
MDAC components but we're on the latest version already. Also seen reference
to Unique indexes with null values - not the case here. The table in
question is a simple address table with 52 columns, three indexes (one
unique), and works perfectly fine in the Dynamics AX environment or through
SQL Server Management Studio. It only seems to be Access that has this issue.
Help is appreciated.
Nate