|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I've got Access 2003 and I'm connecting to a SQL Server database using ODBC.
The structure of the table I'm trying to link to is huge. It has over 600
fields, yet only has about 700 records. When I look at the linked table, it's
missing the last 100 fields or so and the last 150 records. In other words,
it's not bringing over the entire table, just part of it. There is no
indication that this is happening (dialog box, error message, etc.), but in
comparing the original table and the linked table, the problem is obvious.
Is there a way to expand the capacity of ODBC so that the entire table is
brought over?
Thx,
Shane
|
|
Hi Shane,
The limit isn't with ODBC but with the number of columns Access can handle
in a table.
--
Cindy Winegarden MSCD, Microsoft Visual FoxPro MVP
cindy_winegarden[ at ]msn.com www.cindywinegarden.com
"Shane" <Shane[ at ]discussions.microsoft.com> wrote in message
news:CD5BD73B-9AE8-4BC7-A5D9-3AF0758AE4A4[ at ]microsoft.com...
[Quoted Text] > I've got Access 2003 and I'm connecting to a SQL Server database using
> ODBC.
> The structure of the table I'm trying to link to is huge. It has over 600
> fields, yet only has about 700 records. When I look at the linked table,
> it's
> missing the last 100 fields or so and the last 150 records. In other
> words,
> it's not bringing over the entire table, just part of it. There is no
> indication that this is happening (dialog box, error message, etc.), but
> in
> comparing the original table and the linked table, the problem is obvious.
>
> Is there a way to expand the capacity of ODBC so that the entire table is
> brought over?
>
> Thx,
> Shane
|
|
That's what I would have thought, but he's implying that about 500 columns
are being returned: Access should only allow 255.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Cindy Winegarden" <cindy_winegarden[ at ]msn.com> wrote in message
news:ebNqBGpAGHA.2156[ at ]TK2MSFTNGP11.phx.gbl...
[Quoted Text] > Hi Shane,
>
> The limit isn't with ODBC but with the number of columns Access can handle
> in a table.
>
> --
> Cindy Winegarden MSCD, Microsoft Visual FoxPro MVP
> cindy_winegarden[ at ]msn.com www.cindywinegarden.com
>
>
> "Shane" <Shane[ at ]discussions.microsoft.com> wrote in message
> news:CD5BD73B-9AE8-4BC7-A5D9-3AF0758AE4A4[ at ]microsoft.com...
>> I've got Access 2003 and I'm connecting to a SQL Server database using
>> ODBC.
>> The structure of the table I'm trying to link to is huge. It has over 600
>> fields, yet only has about 700 records. When I look at the linked table,
>> it's
>> missing the last 100 fields or so and the last 150 records. In other
>> words,
>> it's not bringing over the entire table, just part of it. There is no
>> indication that this is happening (dialog box, error message, etc.), but
>> in
>> comparing the original table and the linked table, the problem is
>> obvious.
>>
>> Is there a way to expand the capacity of ODBC so that the entire table is
>> brought over?
>>
>> Thx,
>> Shane
>
>
|
|
hi Shane,
Shane wrote
[Quoted Text] > I've got Access 2003 and I'm connecting to a SQL Server database using ODBC.
> The structure of the table I'm trying to link to is huge. It has over 600
> fields, yet only has about 700 records.
I am not sure wether this is a correct normalized table, but you can use
views to reduce the number of columns. Just select the relevant ones.
mfG
--> stefan <--
|
|
Actually, I believe Cindy is correct. I was just estimating on what was
coming over, but when I actually counted the columns, it was 255.
"Douglas J. Steele" wrote:
[Quoted Text] > That's what I would have thought, but he's implying that about 500 columns > are being returned: Access should only allow 255. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele> (no e-mails, please!) > > > > "Cindy Winegarden" <cindy_winegarden[ at ]msn.com> wrote in message > news:ebNqBGpAGHA.2156[ at ]TK2MSFTNGP11.phx.gbl... > > Hi Shane, > > > > The limit isn't with ODBC but with the number of columns Access can handle > > in a table. > > > > -- > > Cindy Winegarden MSCD, Microsoft Visual FoxPro MVP > > cindy_winegarden[ at ]msn.com www.cindywinegarden.com > > > > > > "Shane" <Shane[ at ]discussions.microsoft.com> wrote in message > > news:CD5BD73B-9AE8-4BC7-A5D9-3AF0758AE4A4[ at ]microsoft.com... > >> I've got Access 2003 and I'm connecting to a SQL Server database using > >> ODBC. > >> The structure of the table I'm trying to link to is huge. It has over 600 > >> fields, yet only has about 700 records. When I look at the linked table, > >> it's > >> missing the last 100 fields or so and the last 150 records. In other > >> words, > >> it's not bringing over the entire table, just part of it. There is no > >> indication that this is happening (dialog box, error message, etc.), but > >> in > >> comparing the original table and the linked table, the problem is > >> obvious. > >> > >> Is there a way to expand the capacity of ODBC so that the entire table is > >> brought over? > >> > >> Thx, > >> Shane > > > > > > > |
|
Your right, Cindy. There are only 255 columns that come over.
"Cindy Winegarden" wrote:
[Quoted Text] > Hi Shane,
>
> The limit isn't with ODBC but with the number of columns Access can handle
> in a table.
>
> --
> Cindy Winegarden MSCD, Microsoft Visual FoxPro MVP
> cindy_winegarden[ at ]msn.com www.cindywinegarden.com
>
>
> "Shane" <Shane[ at ]discussions.microsoft.com> wrote in message
> news:CD5BD73B-9AE8-4BC7-A5D9-3AF0758AE4A4[ at ]microsoft.com...
> > I've got Access 2003 and I'm connecting to a SQL Server database using
> > ODBC.
> > The structure of the table I'm trying to link to is huge. It has over 600
> > fields, yet only has about 700 records. When I look at the linked table,
> > it's
> > missing the last 100 fields or so and the last 150 records. In other
> > words,
> > it's not bringing over the entire table, just part of it. There is no
> > indication that this is happening (dialog box, error message, etc.), but
> > in
> > comparing the original table and the linked table, the problem is obvious.
> >
> > Is there a way to expand the capacity of ODBC so that the entire table is
> > brought over?
> >
> > Thx,
> > Shane
>
>
>
|
|
What exactly do you mean by "coming over"?
I've linked to data sources that had in excess of 255 columns. All I did was
create queries that returned less than 255 columns from the total number of
columns.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Shane" <Shane[ at ]discussions.microsoft.com> wrote in message
news:B19A04F4-8399-4873-AC92-5074DF353AF3[ at ]microsoft.com...
[Quoted Text] > Actually, I believe Cindy is correct. I was just estimating on what was > coming over, but when I actually counted the columns, it was 255. > > "Douglas J. Steele" wrote: > >> That's what I would have thought, but he's implying that about 500 >> columns >> are being returned: Access should only allow 255. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele>> (no e-mails, please!) >> >> >> >> "Cindy Winegarden" <cindy_winegarden[ at ]msn.com> wrote in message >> news:ebNqBGpAGHA.2156[ at ]TK2MSFTNGP11.phx.gbl... >> > Hi Shane, >> > >> > The limit isn't with ODBC but with the number of columns Access can >> > handle >> > in a table. >> > >> > -- >> > Cindy Winegarden MSCD, Microsoft Visual FoxPro MVP >> > cindy_winegarden[ at ]msn.com www.cindywinegarden.com >> > >> > >> > "Shane" <Shane[ at ]discussions.microsoft.com> wrote in message >> > news:CD5BD73B-9AE8-4BC7-A5D9-3AF0758AE4A4[ at ]microsoft.com... >> >> I've got Access 2003 and I'm connecting to a SQL Server database using >> >> ODBC. >> >> The structure of the table I'm trying to link to is huge. It has over >> >> 600 >> >> fields, yet only has about 700 records. When I look at the linked >> >> table, >> >> it's >> >> missing the last 100 fields or so and the last 150 records. In other >> >> words, >> >> it's not bringing over the entire table, just part of it. There is no >> >> indication that this is happening (dialog box, error message, etc.), >> >> but >> >> in >> >> comparing the original table and the linked table, the problem is >> >> obvious. >> >> >> >> Is there a way to expand the capacity of ODBC so that the entire table >> >> is >> >> brought over? >> >> >> >> Thx, >> >> Shane >> > >> > >> >> >>
|
|
|