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