Hi

A200 has a limit or 32,000+ objects.
What is the definition of an 'object'?
Does it include controls on a form etc as they are referred to as objects as
well in documentation?
What does the table MSysQueries count as it has 22,000 records but I don't
have that many queries?

Sorry for multiple questions but just trying to work out how close to limits
a db is and can't find any clear explanation.

MSysQueries contains many records for each query. For instance, it has a
record to define each field or calculated column in a query that is being
displayed in the results. So it is possible, that a single query will have 20
or 30 or more records in the MSysQueries table.

I really don't know the definition of objects. I do know that Tables, Forms,
Reports, Modules, and macros are all objects. You can list the ***database
objects*** (in Access 2003 and earlier) by selecting File: Database Properties
and then clicking on the contents tab.

John Spencer
Access MVP 2002-2005, 2007-2011

On 7/12/2011 1:50 AM, JeffP wrote:

On Tue, 12 Jul 2011 15:50:54 +1000, "JeffP" <no-reply (AT) asken (DOT) com.au>
wrote:

I don't know. I would assume each of tables, queries, forms, reports,
macros and modules is an object but I don't know that.

You will likely run into the following problem the soonest.

ACC2000: "Microsoft Access Was Unable to Create an MDE Database" Error
Message http://support.microsoft.com/kb/202304

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/

SQL Server / Access Data Projects don't have limits on numbers of queries.