Problem with link dialog list >= 35000 entries

[Guest]

Hi, maybe someone more experienced than me can try to reproduce this, it
might be a limit/bug in Access 2003:

When trying to link to a table from a DB with >= 35000 entries (= sum of
tables, views and synonyms) I am not able to link correctly to the last table
in the link dialog list.

I first encountered this with Oracle 9 via ODBC but can reproduce the
problem linking to an Access mdb with >= 35000 tables.

Could it be that Access uses an integer variable (<=32767) for the dialog
list index?

 

[Brendan Reynolds]

The maximum number of objects in an MDB is 32,768. See the 'Specifications'
help topic at the following URL ...

http://office.microsoft.com/assista...gin=EC010227091033&QueryID=-_a74pDus&respos=1

 

[Guest]

Thanks for your quick answer. I found a workaround for my Oracle / ODBC
Problem by altering the following value in the registry:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\ODBC]
"AttachableObjects"="'TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'"

In my case, excluding 'SYNONYM' from the attachable objects reduced the list
in the link dialog to < 32768.