If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Repeats First Row Of Data
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. -- Tom At AgFirst |
#2
|
|||
|
|||
Access Repeats First Row Of Data
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) On Apr 7, 8:13*am, TomAtAgFirst wrote: 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. -- Tom At AgFirst |
#3
|
|||
|
|||
Access Repeats First Row Of Data
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 "TomAtAgFirst" wrote in message ... 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. -- Tom At AgFirst |
#4
|
|||
|
|||
Access Repeats First Row Of Data
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. "TomAtAgFirst" wrote in message ... 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. -- Tom At AgFirst |
#5
|
|||
|
|||
Access Repeats First Row Of Data
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) On Apr 8, 7:01*am, "GP George" wrote: 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. "TomAtAgFirst" wrote in message ... 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. -- Tom At AgFirst |
Thread Tools | |
Display Modes | |
|
|