473,231 Members | 1,642 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

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 1966
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: edo | last post by:
Following is a summary of articles spanning a 7 day period, beginning at 12 Dec 2003 05:22:35 GMT and ending at 19 Dec 2003 04:09:06 GMT. Notes ===== - A line in the body of a post is...
8
by: Thats Me | last post by:
Background: Access 2000 running on Windows 2000, Did not design inherited (three previous database maintainers in last 18 months), Non-existent comments for existing code modules and objects, six...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
29
by: Patrick | last post by:
I have the following code, which regardless which works fine and logs to the EventViewer regardless of whether <processModel/> section of machine.config is set to username="SYSTEM" or "machine" ...
2
by: Robert Smith jr. | last post by:
Hello, Please pardon my newbie question ... I am building an ASP.NET page that displays a recordset with a Delete statement enabled (this all works fine). I want to Insert the current row...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
0
by: comp974 | last post by:
ok, here is the situation, I am trying to construct a table with several ASP.net 2.0 controls in it during execution time in an VB.net enviroment. For starters, I have a textbox and a linkbutton...
4
by: Debbiedo | last post by:
My software program outputs an XML Driving Directions file that I need to input into an Access table (although if need be I can import a dbf or xls) so that I can relate one of the fields...
6
by: Wesley Peace | last post by:
I hate to cross post, but I've gotten no answer yet on a problem I'm having with visual studio 2008. I've created a series of forms with controls to access a Access database tables. The...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.