Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

ODBC TABLE SET

Discussion in 'Information Technology' started by fid_ed, Jul 28, 2006.

Tags:
  1. fid_ed

    fid_ed
    Expand Collapse
    Guest

    I am setting up an ODBC connection to an oracle db using linked tables. When
    th e list of available tables comes back it is only a subset of the tables I
    know are in the db. Any ideas?
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Yepp, dependant on the version of Access the number of tables returned are
    limited (don't remember the figures - but it's 255 for '97 i believe)
    I Use a Passthrough query against the database :
    SELECT TABLE_NAME FROM USER_TABLES '(or ALL_TABLES)
    And save it As User Tables

    I Then Use The
    DoCmd.TransferDatabase method (or CreateTableDef) in a loop to link all
    tables

    incomplete code (away from access at the moment)

    Dim Db As DAO.Database
    Dim Rs AS DAO.Recordset

    Set Db = CurrentDb
    Set Rs = Db.OpenRecordset("USER_TABLES",DbOpenSnapshot)
    While Not Rs.EOF
    DoCmd.TransferDatabase aclink,"ODBC;DSN=xxx;uid=yyy;pwd=zzz","ORAUSER." &
    Rs.Fields("TABLE_NAME").Value ....
    Rs.Movenext
    Wend
    Rs.Close : Set Rs = Nothing
    Set Db = Nothing

    HTH

    Pieter




    "fid_ed" <fid_ed@discussions.microsoft.com> wrote in message
    news:E47A5E49-894C-496D-A305-5198591BAC48@microsoft.com...
    >I am setting up an ODBC connection to an oracle db using linked tables.
    >When
    > th e list of available tables comes back it is only a subset of the tables
    > I
    > know are in the db. Any ideas?




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4367 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Yepp, dependant on the version of Access the number of tables returned are
    limited (don't remember the figures - but it's 255 for '97 i believe)
    I Use a Passthrough query against the database :
    SELECT TABLE_NAME FROM USER_TABLES '(or ALL_TABLES)
    And save it As User Tables

    I Then Use The
    DoCmd.TransferDatabase method (or CreateTableDef) in a loop to link all
    tables

    incomplete code (away from access at the moment)

    Dim Db As DAO.Database
    Dim Rs AS DAO.Recordset

    Set Db = CurrentDb
    Set Rs = Db.OpenRecordset("USER_TABLES",DbOpenSnapshot)
    While Not Rs.EOF
    DoCmd.TransferDatabase aclink,"ODBC;DSN=xxx;uid=yyy;pwd=zzz","ORAUSER." &
    Rs.Fields("TABLE_NAME").Value ....
    Rs.Movenext
    Wend
    Rs.Close : Set Rs = Nothing
    Set Db = Nothing

    HTH

    Pieter




    "fid_ed" <fid_ed@discussions.microsoft.com> wrote in message
    news:E47A5E49-894C-496D-A305-5198591BAC48@microsoft.com...
    >I am setting up an ODBC connection to an oracle db using linked tables.
    >When
    > th e list of available tables comes back it is only a subset of the tables
    > I
    > know are in the db. Any ideas?
     

Share This Page