Table ID Count

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Vincent

    Table ID Count

    There has been a lot of mention about a limit of 2048 as the number of
    table ids that can be maintained by Access. How is this value
    obtained? Any help is appreciated. Thanks.

    Vincent
  • Salad

    #2
    Re: Table ID Count

    Vincent wrote:
    There has been a lot of mention about a limit of 2048 as the number of
    table ids that can be maintained by Access. How is this value
    obtained? Any help is appreciated. Thanks.
    >
    Vincent
    I'm not sure what a table id is but if you want the number of tabledefs,
    including the system tabledefs, you could enter
    msgbox currentdb.Table Defs.Count

    Comment

    Working...