MS SQL Server ODBC - Table Problems with Access Linked to SQL Server 2005

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Table Problems with Access Linked to SQL Server 2005

chfran

2006-10-24, 6:40 pm

I have a variety of Access tables linked to SQL Server 2005. A couple
of the tables are having problems. The table in SS has ~7000 records.
If I pull up the same table (linked) it has the same number of records
but two records are repeated over a thousand times. Remember, the
record count for the table in SS or Access is the same but the record
isn't repeated countless times in SS.

Any ideas?

Is this a problem with ODBC

Thank you in advance.

Sponsored Links