Size Limits or Recommendations on Access Databases

K

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.
 
T

Tony Toews

Lee said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

access 2.0 limts 2
DB Size 2
2 Gig Limit 4
limits in PDF file created from Access 7 report 2
Reducing Database Size 2
Send Anywhere or similar program ? 8
Database Size Limit 1
Access Database Maximum Size 3

Top