Prev: Data Access Page
Next: Fields not showing on Report
From: TomAtAgFirst on 7 Apr 2010 11:13
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
From: a a r o n . k e m p f on 7 Apr 2010 15:10
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
<TomAtAgFi...(a)discussions.microsoft.com> 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

From: Gina Whipp on 7 Apr 2010 20:09
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" <TomAtAgFirst(a)discussions.microsoft.com> wrote in message
news:E7C73A3A-44F6-4ED7-89E4-CFC0950CFE5E(a)microsoft.com...
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

From: GP George on 8 Apr 2010 10:01
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" <TomAtAgFirst(a)discussions.microsoft.com> wrote in message
news:E7C73A3A-44F6-4ED7-89E4-CFC0950CFE5E(a)microsoft.com...
> 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

From: a a r o n . k e m p f on 8 Apr 2010 16:29
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" <george_hepwo...(a)hotmail.com> 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" <TomAtAgFi...(a)discussions.microsoft.com> wrote in message
>
> news:E7C73A3A-44F6-4ED7-89E4-CFC0950CFE5E(a)microsoft.com...
>
> > 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

 | 
Pages: 1
Prev: Data Access Page
Next: Fields not showing on Report