Access Object Limit?

[bkf7911]

Is there a limit to the number of Objects (tables, queries, forms, etc.) that any 1 access database can have? I ask b/c mine is getting all squirrely. I lost about 60 sub-reports in one version, and i'm thinking it may be due to the number of objects. Luckily, i make copies of them all the time, so i have a backup.

 

[Ed2020]

32768 is the limit. Although Access Help doesn't say I seem to remember that this is over the lifetime of the database - deleting objects does not allow more to be added. You can always import them all into a new MDB though.

Ed Metcalfe.

Please do not feed the trolls.....

 

[ZmrAbdulla]

Ed is correct.. access keep count of deleted objects & controls in memory.

more on limits

http://www.databasezone.com/techdocs/acclimit.html

or have a search in help file keywords like "Access specifications" or "limits"

________________________________________________________
Zameer Abdulla
Help to find Missing people