如何增加ms访问数据库的大小?我使用access2007. [英] how to increase ms access database size? i using access2007.

问题描述

专家，

我开发了一个Windows应用程序，后端数据库是access2007.我听说access2007的最大限制是2GB.现在我的问题是，它们是否有办法提高访问大小?如何为应用程序创建多个数据库以增加大小和性能.

在此先感谢...

hi experts,

I developed a windows application,Back end DB was access2007. i heard that Max limit of access2007 is 2GB. Now my question is, is their any way to improve access size?, how to create more than one db for a application to increasing size and performance.

Thanks in advance...

推荐答案

Access 2007的最大限制为2GB.你不能超过那个.
http://office.microsoft.com/en-us/access- help/access-2007-specifications-HA010030739.aspx [ ^ ]
您将必须查看您的数据，并找到某种方式可以将其划分为多个数据库.

或者，转储Access并改用SQL Server-2008R2支持10GB数据库，而SQL 2012支持高达524,272 TB:WTF:
http://msdn.microsoft.com/en-us/library/ms143432.aspx [ ^ ]

The max limit for an Access 2007 is 2GB. You cannot exceed that.
http://office.microsoft.com/en-us/access-help/access-2007-specifications-HA010030739.aspx[^]
You would have to look at your data, and work out some way in which it could be partitioned into multiple databases.

Or, dump Access and use SQL Server instead - 2008R2 supports 10GB databases, and SQL 2012 supports up to 524,272 terabytes :WTF:
http://msdn.microsoft.com/en-us/library/ms143432.aspx[^]

这篇关于如何增加ms访问数据库的大小?我使用access2007.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！