I created an Access 2003 database and attempted to link tables to an
Oracle database. Access must have a limitation on how many tables it
can list. For example tables beginning with 'A'-'G' are fine but
tables beginning with 'H' only show a few then the list stops. Has
anyone else had this problem? Is there a way around this perhaps with
another version such as Access 2007 or 2010?

Per Know39:
All my tables start with "tbl" (volatile tables), "tlkp" (lookup
tables), "ttbl" (temporary work tables), "zmtbl" (tables used as
models), or "zstbl" (system tables of no interest to user).

This is a watered-down version of the scheme proposed by
Leszynski and Reddick.

My biggest app has 168 tables - no problem.

I would recommend the prefixes.

Part of the rationale for the prefixes is that in some
lists/collections tables and queries both appear - and the
prefixes ("qry" for queries....) go a long way towards clarity.

Also the "tbl" vs others groups the "bread-and-butter" tables,
making it easier to get a feel for the data structure.
--
PeteCresswell

On Wed, 14 Sep 2011 07:08:52 -0700 (PDT), Know39
<ken.nowinski (AT) gmail (DOT) com> wrote:

I don't think there is such a limitation. You can test this by
creating a new empty db and attaching some H-tables. My guess is they
will fail again.

-Tom.


Microsoft Access MVP

On Wed, 14 Sep 2011 07:08:52 -0700 (PDT), Know39
<ken.nowinski (AT) gmail (DOT) com> wrote:

How many tables? Is it a table name length limit? Access allows
about 51 characters for an object name.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

On 15/09/2011 02:06:00, Tony Toews wrote:
Might be worth looking at
http://www.databasedev.co.uk/access_specifications.html
to see if limits are being exceeded.
The OP has not given any idea of the number of tables he is trying to link in
(and the number of objects in the Db)

I don't know how later versions of access (2007 & 2010) have changed the
limits, nor do we know what version of Access the OP is using, but I guess
the limits have not decreased.

Phil