Link table table list is incomplete

[Guest]

I'm running Access 2002. When trying to create a link table to an oracle
database with a large number of tables, the list of tables loaded for
selection is incomplete. I see all tables expected up to a point, about 500
I guess. It's behaves as if a size limit is reached, but no message is given.

Does anyone know of a limitation to the number of tables in this list?
Does anyone know how to increase this list size?
Does anyone know of a different way to create a link table?

Thanks

 

[Guest]

Actually, the list size if much larger than 500, closer to 32k, probably
32767. I just noticed the post "Problem with link dialog list..." by Will.
In that post, Brendan Reynolds confirms this limitation.

If Will's solution, to modify the registry to eliminate object types, does
not reduce the list size so the desired table is displayed and selectable, is
there another way to create a link to the non-displayed table(s)?

 

[Douglas J Steele]

You can create the linked tables in code, without using the dialog at all.

More work, of course...