Table Problems with Access Linked to SQL Server 2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

.

Relevant Pages

  • Re: Boss wants me to program
    ... It allows you to create GUI apps that can work with a variety of database options, such as Access or MS SQL Server. ...
    (comp.lang.python)
  • ANN: SQLExecMS 2.1 has been released
    ... with SQL server or MSDE. ... In addition to variety of abilities provided by version 2.0, ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: more SQL things
    ... >> A whole host of applications written in a variety of languages are ... >> From the SQL Server admin Console you can do certain MS Access like ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: SQLExecMS 2.1 has been released
    ... > with SQL server or MSDE. ... > In addition to variety of abilities provided by version 2.0, ...
    (borland.public.delphi.thirdpartytools.general)