Access Database Capacity
Home > IT Answers > Database > Access Database Capacity
Tlee
10 pts.
0
Q:
Access Database Capacity
Access Data Volume, Microsoft Access, Access Database, Access Database Capacity
What is the data volume that an Access Database can effectively handle?
ASKED: Jun 24 2009  2:42 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47440 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
It's recommended that you not try and put more than 1 Gig of data into a single access database as that's about the most the Jet engine can effective handle.
Last Answered: Jun 25 2009  1:39 AM GMT by Mrdenny   47440 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Findsarfaraz   1395 pts.  |   Jun 29 2009  3:54PM GMT

With MS Access 2007 the limit is now 2GB. For reference visit the link below

 <a href="http://blogs.msdn.com/access/archive/2006/06/05/access-2007-limits.aspx" title="http://blogs.msdn.com/access/archive/2006/06/05/access-2007-limits.aspx" target="_blank">http://blogs.msdn.com/access/archive/200…</a>

Regards,
Sarfaraz Ahmed
MS Excel help

 
0