Maximum limits in an Access project (1 Viewer)

[amorosik]

What are the maximum limits of a procedure created with Access?
I mean, is there a maximum number of forms?
Of Reports? Module?
Is there a maximum length of a module?
Is there official Microsoft information on the maximum limits for a project created with Access?

And do they depend on the versions?
In the sense that Access2019 has more limits than Access2000?

 

[Cotswold]

Typing "ms access limits", or "ms access specifications", or a combination into your browser search, should do the job

 

[isladogs]

See

Access specifications - Microsoft Support

Find limits and specifications for Access 2016 database files and objects, such as the maximum file size or the maximum number of fields in a table.

support.microsoft.com

Whilst most of the limits in that article are correct, some are out of date and should be treated as guidelines. See also two articles on my website:

Access Specification issues

Microsoft publishes a list of Access specifications and limits. Most of the information is correct. This article discusses some specification items that are misleading, out-of-date or inaccurate

www.isladogs.co.uk

Now you CAN open more tables and databases

This short article outlines two recent improvements made to the Access architecture behind the scenes. Taken together, these should significantly reduce the number of 'cannot open any more tables/databases' messages and make it far less likely that Access applications will crash

www.isladogs.co.uk

 

[GPGeorge]

What are the maximum limits of a procedure created with Access?
I mean, is there a maximum number of forms?
Of Reports? Module?
Is there a maximum length of a module?
Is there official Microsoft information on the maximum limits for a project created with Access?

And do they depend on the versions?
In the sense that Access2019 has more limits than Access2000?

While there are technical specifications and limits, and you can find those at the references previously posted, there are also practical limits to the usability of any given application. For example, IMO, it would be very, very rare for a usable Access relational database application to include thousands of reports, even if you can, technically, create that many.

For that reason, the only limit to which I pay particular attention is the overall 2 GB size limitation, which again, has a practical limit of around half that technical specification.

More recent versions of Office do require more memory than earlier versions, so in that sense, there is at least one more stringent limit on Access 365.