Microsoft Access Maximum Objects is 32768.  What objects are counted?

Posted on 2010-01-01
Last Modified: 2013-11-29
What objects are included in the 32768?

How do I know when I am close?
Question by:JBB9906
    LVL 4

    Expert Comment

    Hi JBB9906

    The 32768 refers to the maximum number that the "integer" datatype can store. The minimum is -32768. To store bigger numbers look at using the "long integer" datatype which can store a maximum of 2,147,483,647 and  a minimum of -2,147,483,647.
    LVL 84
    Your information is correct: 32768 is the maximum number of objects an Access database can hold. The information from northfields, while technically correct, is not really relevant to your question.

    In regard to your question: Objects include forms, reports, tables, queries, table fields, controls on your forms/reports, etc etc - at least as far as I know!

    And if you're even CLOSE to the maximum your database is far too complex ;)

    LVL 56

    Accepted Solution

    It refers to only objects within the database container; tables, queries, forms, reports, and macro's.
    LVL 56

    Assisted Solution

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    To be a bit clearer, msysobjects can only have 32768 rows.  
    There are a few things (like temp queries), which may exist in the DB but you won't see in the the database container.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now