Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2008
    Location
    Columbia, South Carolina, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    External Data Source Limitation (2003)

    I am trying to add DB2 external data sources to MS Access. All goes well except that when Access presents the listbox containing the tables I can select from, the list box only contains the first couple of hundred tables (I didn't count, but the list began with the A's and ended midway in the C's). I need tables down in the F's. I'm guessing the listbox is limited in size and the only way I will be able to add the tables I need is by doing some VBA coding on my own. Any other ideas about how to approach this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: External Data Source Limitation (2003)

    Welcome to Woody's Lounge!

    You can use code like this:
    <code>
    DoCmd.TransferDatabase acLink, "ODBC Database", _
    "ODBC;DSN=DataSource1;DATABASE=pubs", _
    acTable, "SourceTableName", "TargeTableName"
    </code>
    You'll have to find out what connection string you have to use for DB2, I can't help you with that.

Posting Permissions

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