Dizzydee20
asked on
MS Access Storage Capacity
Hi Experts,
I will be teaching a Beginner's Access course in November and I wanted to be able to tell my participants what the storage capacity of Access. That way I can advise them to consider a more robust DB like SQL if they know they will exceed the storage capacity of Access. Thanks.
I will be teaching a Beginner's Access course in November and I wanted to be able to tell my participants what the storage capacity of Access. That way I can advise them to consider a more robust DB like SQL if they know they will exceed the storage capacity of Access. Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Pardon me for saying so, but if you don't know this stuff should you be teaching the course and advising on Access vs SQL Server?
> 25Mb or so.
I've got a few running at 800MB+ :-)
I've got a few running at 800MB+ :-)
Lookup specifications in the help file....why post that question here when the information is so readily available? Below is from the Access 2003 help file....Mike
Attribute Maximum
Microsoft Access database (.mdb) (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.) file size 2 gigabytes minus the space needed for system objects (system object: Database objects that are defined by the system, such as the table MSysIndexes, or by the user. You can create a system object by naming the object with USys as the first four characters in the object name.).
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
Attribute Maximum
Microsoft Access database (.mdb) (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose. The Microsoft Jet database engine manages the data.) file size 2 gigabytes minus the space needed for system objects (system object: Database objects that are defined by the system, such as the table MSysIndexes, or by the user. You can create a system object by naming the object with USys as the first four characters in the object name.).
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
> I've got a few running at 800MB+ :-)
Zowie Batman. That's a lot... =1 user I hope?
Zowie Batman. That's a lot... =1 user I hope?
Nope. 5-10 users.
I had a 405mb mdb with 22 users before we switched to sql server....imho, it's really more the number of users than the size of the db that seriously affects performance
Agree with Sid on that.
ASKER
Thanks for the comments all...
the limitations of MS access 2003 data's store
Beginner's Access course = Usually a bunch of secretaries that may have experience importing Excel spreadsheets into a table, and running queries. Been there, taught that.
Hope this helps.
-Jim