How many tables,queries,forms, and reports are to many for one Database?

[Daisy509th]

I worry about the weridest things but I am wanting to know when is to much to much for my access database.
For one database:
Tables=
Forms=


Querries=
Records in a table=
Records in a database=

or are all these things considered objects and in that case how many objects are to many?

Thanks for the help as always,


Yes, i have read alot of articles trying to figure this out and all I have done is confuse myself more.

[ranman256]

you are limited to 2 Gig in a db.
i have hundreds of queries.
most db do not need hundreds of Tables, but I did get 2 million records in 1 table, but hit my 2 gig limit.

it should handle any avg company data.
(but not if you are Amazon)

[isladogs]

Attached are some statistics generated for one of my Access databases - FE approx 140MB and 3 linked BE files with most linked tables in SQL Server




Its nowhere near the limit of what can be done in Access and its still fast/responsive to use

However there are some built in limits for different Access objects e.g. maximum number of controls in a form is approx 750
See http://www.databasezone.com/techdocs/acclimit.html