I have a couple of linked tables in my access database. These tables are linked to a SQL Server on the lan.
When I click on the table 1, I can see all data in 88 rows.
I have a 2nd table with 4000 rows. When I click on this table, I am seeing
the first 88 rows correctly, but the next 3922 rows are showing identicle
data? (Which ins't true) When I do a select on this table from SQL Server Management Studio, I can see all rows are NOT the same.
Any clues on this issue?
I am on Windows 7 and Office 2010 Professional. (SQL Server 2008)
I also have an XP running Office 2003. Same MDB file with linked tables, but
the issue DOES NOT exist on this. Maybe ODBC issue? Maybe Windows 7, or maybe Access 2010 issue.
Thanks,