469,291 Members | 1,847 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,291 developers. It's quick & easy.

Access 2000 does not see summary table in DB2 UDB

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
Nov 12 '05 #1
3 1822
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.spammarshall.com>

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

Sam Brunetti wrote:
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

Nov 12 '05 #2
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 <fo***********@yahoo.com> wrote in message news:<3F**************@yahoo.com>...
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.spammarshall.com>

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

Sam Brunetti wrote:
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

--

Nov 12 '05 #3
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.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Thats Me | last post: by
29 posts views Thread by Patrick | last post: by
2 posts views Thread by Robert Smith jr. | last post: by
52 posts views Thread by Neil | last post: by
reply views Thread by comp974 | last post: by
6 posts views Thread by Wesley Peace | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.