What is the largest database size allowed in Microsoft access 2007?

What is the largest database size allowed in Microsoft access 2007?


Troush2009Asked:
Who is Participating?
 
VTKeganCommented:
2GB
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
2 GB in a single ACCDB.

But keep in mind that if you use a Split architecture ... Data tables only in a Common Back End db ... and everything else in Front End db ... you effectively can create more space of sorts.

mx
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Patrick MatthewsCommented:
Carrying on with that theme, a split architecture can have >1 "back end".  So, while each MDB / ACCDB file is limited to 2 GB, the entire app with all of its data stores can be considerably larger.

That said, I think it's tempting fate to have files that get much north of 1 GB.  At that stage, one should be thinking about upsizing to a SQL Server back end.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
When an Access db approaches the 2GB limit ... it's sort of like approaching a Black Hole.

mx
0
 
Patrick MatthewsCommented:
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Yep ... that's IT !

mx
0
 
Troush2009Author Commented:
Thanks!
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
2GB is the limit, but as Mx said, you can split things.  In fact you can take that even further by putting one table in each DB, so the limit really is a 2GB table.

However if you do that, the only problem is that you cannot enforce relationships across the DB's.

  Also keep in mind that 2GB is not all that big given that all text is stored in unicode, which is 2 bytes per character.

JimD.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.