External Data Source Limitation (2003)

[3gm]

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?

[HansV]

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.