A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access Repeats First Row Of Data



 
 
Thread Tools Display Modes
  #1  
Old April 7th, 2010, 04:13 PM posted to microsoft.public.access
TomAtAgFirst
external usenet poster
 
Posts: 1
Default 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  
Old April 7th, 2010, 08:10 PM posted to microsoft.public.access
a a r o n . k e m p f @ g m a i l . c o m
external usenet poster
 
Posts: 1,108
Default 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  
Old April 8th, 2010, 01:09 AM posted to microsoft.public.access
Gina Whipp
external usenet poster
 
Posts: 3,500
Default 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  
Old April 8th, 2010, 03:01 PM posted to microsoft.public.access
GP George[_2_]
external usenet poster
 
Posts: 49
Default 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  
Old April 8th, 2010, 09:29 PM posted to microsoft.public.access
a a r o n . k e m p f @ g m a i l . c o m
external usenet poster
 
Posts: 1,108
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.