Link table table list is incomplete


G

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
 
Ad

Advertisements

G

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)?
 
Ad

Advertisements

D

Douglas J Steele

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

More work, of course...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top