Size Limits or Recommendations on Access Databases

[Lee]

Is there a size limit or recommended usage limit for an
Access Database?

 

[Kristyn Wagoner [MSFT]]

You can find this information and more by going to Help within Access and
type in "Specifications".




Attribute Maximum
Microsoft Access database (.mdb) file size 2 gigabytes minus the space
needed for system objects
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set
to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255

--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Tony Toews]

Is there a size limit or recommended usage limit for an
Access Database?

Somewhere between 10 and 20 or 30 users updating at one time seems to
be the practical limit. Any number of users inquiring or reporting.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm