• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 927
  • Last Modified:

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

What objects are included in the 32768?

How do I know when I am close?
Jeff
0
JBB9906
Asked:
JBB9906
  • 2
2 Solutions
 
northfieldsCommented:
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.

http://www.blabla.co.za/2008/11/10/access-number-data-type-field-sizes/
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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 ;)

0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
It refers to only objects within the database container; tables, queries, forms, reports, and macro's.
JimD.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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.
JimD.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now