How to determine number of objects in db for max size/complexity?

  • Thread starter Thread starter Brainwave Surfer
  • Start date Start date
B

Brainwave Surfer

How to determine number of objects in db for max size/complexity?

I'm doing a sorta large project, and am aware of the 700 (roughtly)
object limit in Access. How do, or, CAN we find out where we are on
that count to see if I need to split my application into 2 db's, or what?

Jim
 
The maximum number of objects in an Access db is 32,000+ (tables, forms,
etc.)

Your db should be split into two (tables in one, everything else in the
other) if you are in a multi-user environment.

Further splitting may be necessary if your tables are very large and
approaching the max file size limit.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Hey, thanks... in a post or help, the 700 number i was concerned about
was for the lifetime of a FORM, not the entire project... (whew...)

i found my answer in

help

access help

access specifications


and the numbers were in there.. everything... Thanks for that pointer..

Jim
 
Back
Top