Re: get external data odbc limitation?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi, Brinky.

The selection box that comes up is limiting the number of
tables that I can choose.

Actually, it's limiting the number of characters that can be displayed, not
the number of tables. Up to 64K of characters will appear in the list. The
longer the table names, the fewer the table names that will be displayed.

Our database has 50,000 tables in it and the
selection box is only showing the first 3200 or so alphabetically.

That number of tables far exceeds good relational database design and
management.

Is there
a setting somewhere within Access that is limiting the number of tables
that
I can see from the ODBC?

No. You only get 64K characters to display the table names. Use it wisely.

My advice is to connect to the database server as a user who has limited
permissions, not the database administrator, so that only the necessary
tables appear on the list. There's an additional work-around in Oracle, but
you haven't mentioned which database server you're using, so I won't mention
the additional Oracle solution, either.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


"brinky" <u31729@uwe> wrote in message news:6dc281fea1d50@xxxxxx
I am using Access 2003.
I am using the "get external data" "link tables" option and then using a
odbc
type connection. The selection box that comes up is limiting the number
of
tables that I can choose. Our database has 50,000 tables in it and the
selection box is only showing the first 3200 or so alphabetically. Is
there
a setting somewhere within Access that is limiting the number of tables
that
I can see from the ODBC?



.

Relevant Pages

  • Re: Is there a character limit on bound controls?
    ... doesn't mean they all went into the database. ... just fine - I've put more than 1,000 characters in without incident. ... However, on the page that needs to display the text, the text is ... The truncation happens regardless of whether there ...
    (microsoft.public.dotnet.framework.aspnet)
  • Error when trying to display reports
    ... I have made a database using Delphi 4, I tested it and it worked fine. ... Since then I have added more entries (now holds about 50, the database file ... is 10KB) and now it refuses to display. ... 'Cannot create file (a few characters here that don't make sense, ...
    (alt.comp.lang.borland-delphi)
  • RE: traping curly apostrophes
    ... database, and these data will be displayed again on the webform later. ... you found that there are some particular characters which will be ... Based on my experience, this is likely a charset conversion issue, and "?" ... In the display page, you can set breakpoint in the page code and lookup ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: I am trying to create a database in Excel 2004 for Mac
    ... Some database formats are not happy if you use more than 224 characters in a text field. ... in Excel help you'll find that each Excel cell can have 32,767 characters of text (only 1,024 display in a cell; all 32,767 display in the formula). ...
    (microsoft.public.mac.office.excel)
  • Re: Only display certain amount of xters..?
    ... Is it important that the cell *contain all* the input characters, ... Will *limiting the input* to just six characters be good enough? ... You can then enter a warning message that will display when the cell is ...
    (microsoft.public.excel)