Access Repeats First Row Of Data

[TomAtAgFirst]

We are using Access 2007 to link to SQL Server 8.0.2282 tables via ODBC.

When the data is displayed in the Access linked table, we see the correct
number of rows returned; however, all the rows contain the field data for the
first record.

Refresh All appears to fix the issue, but after scrolling down, we discover
after fifty or so rows of unique data, the first field data is repeated again.

Any advice is appreciated.

 

[a a r o n . k e m p f]

sounds to me like Access Linked Tables are the wrong choice for your
problem.
I'd reccomend moving to ADP and poof- all your problems go away.

Otherwise, you'll have to avoid certain datatypes in Access Linked
Tables (BigInt for example- my main datatype for some fields)

 

[Gina Whipp]

TomAtAgFirst,

Have you tried deleting the link and redoing the link?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

We are using Access 2007 to link to SQL Server 8.0.2282 tables via ODBC.

When the data is displayed in the Access linked table, we see the correct
number of rows returned; however, all the rows contain the field data for
the
first record.

Refresh All appears to fix the issue, but after scrolling down, we discover
after fifty or so rows of unique data, the first field data is repeated
again.

Any advice is appreciated.

 

[GP George]

When you created the link to the SQL Server table, did you identify the
Primary Key for that table? Follow Gina's suggestion, making sure you tell
Access which field is the Primary Key.

 

[a a r o n . k e m p f]

or move to ADP, then you don't need to do a whole ton of duplicated
work

Access Data Projects make all this extra work obsolete

that's why jet is depecrated and it always has been (the new version
of Access is NOT jet)

 

[renjudas]

Once you link the table using ODBC DSN, Access will show the tables and select the table you need to link. Then, Access will show the Fields to you from that table. Do not select any fields there. Proceed without selecting will give you the correct result.