Professional Web Applications Themes

Access 2000 does not see summary table in DB2 UDB - IBM DB2

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...

Sponsored Links
  1. #1

    Default 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
    Sponsored Links
    Sam Guest

  2. #2

    Default 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.spammarshall.com>

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

    Sam Brunetti wrote:
     


    Kathy Guest

  3. #3

    Default 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 <com> wrote in message news:<com>... 
    >
    >
    > --[/ref]
    Sam Guest

  4. #4

    Default 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.
    Craig Guest

Similar Threads

  1. summary table
    By Shane in forum IBM DB2
    Replies: 2
    Last Post: October 11th, 04:39 AM
  2. Summary Table and Import
    By Kristi in forum IBM DB2
    Replies: 3
    Last Post: October 9th, 09:59 PM
  3. How to derive summary info from one single table..
    By Anith Sen in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 8th, 01:43 PM
  4. Summary fields or Summary table?
    By Scott in forum FileMaker
    Replies: 1
    Last Post: June 27th, 03:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139