Access 2000 does not see summary table in DB2 UDB

[Sam Brunetti]

Hi,

A user is trying to link a summary table from a DB2 UDB V8.1 (AIX)
database into Access 2000, but the table will not show up in the link
window.
Does anyone know whether this is a known limitation of Access not
being able to see summary tables.? Or is there a way of doing this.

Thank You

[Kathy Benson]

Re: Access 2000 does not see summary table in DB2 UDB

Hi,
I could be wrong on this but I think that ODBC driver for DB2 does not
expose Summary tables. The only exposed types though ODBC specs are:
TABLE, VIEW, SYSTEM_TABLES and SYNONYMS. Therefore, if it is not
supported by the ODBC driver, you will not be able to see them in
Access. Try using another tool such as WinSQL
(http://www.synametrics.com) and see if you get similar behaviour.

KB

--
------------------------------------------------------------------------
This email is certified to be Spam free by Spam Marshall

You don't pay to get spam, why pay to clean it?
Visit http://www.spammarshall.com to create an account for free
<http://www.spammarshal l.com>

------------------------------------------------------------------------

Sam Brunetti wrote:
[color=blue]
>Hi,
>
>A user is trying to link a summary table from a DB2 UDB V8.1 (AIX)
>database into Access 2000, but the table will not show up in the link
>window.
>Does anyone know whether this is a known limitation of Access not
>being able to see summary tables.? Or is there a way of doing this.
>
>Thank You
>
>[/color]

[Sam Brunetti]

Re: Access 2000 does not see summary table in DB2 UDB

Hi Kathy,

Thank you for your response. I am able to see the summary table in the
DB2 UDB control center, so the ODBC driver must be exposing it.
The users are using the same driver, so it could be a limitation of
MS/Access.
I am also able to see the summary table in WinSQL.



Kathy Benson <fornewsgroups@ yahoo.com> wrote in message news:<3F8FD0D8. 9020806@yahoo.c om>...[color=blue]
> Hi,
> I could be wrong on this but I think that ODBC driver for DB2 does not
> expose Summary tables. The only exposed types though ODBC specs are:
> TABLE, VIEW, SYSTEM_TABLES and SYNONYMS. Therefore, if it is not
> supported by the ODBC driver, you will not be able to see them in
> Access. Try using another tool such as WinSQL
> (http://www.synametrics.com) and see if you get similar behaviour.
>
> KB
>
> --
> ------------------------------------------------------------------------
> This email is certified to be Spam free by Spam Marshall
>
> You don't pay to get spam, why pay to clean it?
> Visit http://www.spammarshall.com to create an account for free
> <http://www.spammarshal l.com>
>
> ------------------------------------------------------------------------
>
> Sam Brunetti wrote:
>[color=green]
> >Hi,
> >
> >A user is trying to link a summary table from a DB2 UDB V8.1 (AIX)
> >database into Access 2000, but the table will not show up in the link
> >window.
> >Does anyone know whether this is a known limitation of Access not
> >being able to see summary tables.? Or is there a way of doing this.
> >
> >Thank You
> >
> >[/color]
>
>
> --[/color]

[Craig Wahlmeier]

Re: Access 2000 does not see summary table in DB2 UDB

Oddly enough, you may be able to solve the problem by creating a view
on your summary table. Just a thought...

Craig Wahlmeier
Data-Tronics Corp.