如何在MSAcess MDB上使用2Gb以上数据? [英] How to use more then 2Gb data's on MSAcess MDB?

问题描述

我正在使用Windows应用程序.

我将记录插入为表格.

插入了更多数据. mdb的大小超过2GB，不接受插入数据.
如何解决这个问题.
或选择两个记录作为datagrid

Hi,

I am using Windows application.

I inserting the records as table.

More datas are inserted. The size of mdb as more than 2GB not accept the inserting the datas.
How to solve this.
Or any link to two mdb''s as selecting the records as datagrid

推荐答案

任何要求超过2 GB数据的datagrid的链接都指向两个mdb.如果您的数据库不能在文件系统的限制内生存，则需要找到一种重新设计数据库的方法.我假设大小为b/c，您存储图像，将图像存储在单独的数据库中以及将数据存储在链接到datagrid的主数据库中.

Any datagrid that requires more than 2 GB of data has a usability issue. If your database can''t live within the limits of the file system, you need to work out a way to redesign it. I assume that size is b/c you store images, store them in seperate databases and store your data in the main DB that links to your datagrid.

访问数据库的大小限制为2GB ，没有办法解决

http://www.databasedev.co.uk/access_specifications.html [ http://www.microsoft.com/express/database/ [

Access databases are limited to 2GB in size, no way around this

http://www.databasedev.co.uk/access_specifications.html[^]

You''d need to consider another database, such as SQL Server or SQL Server Express

http://www.microsoft.com/express/database/[^]

SQL Express has a 4GB size limit

这篇关于如何在MSAcess MDB上使用2Gb以上数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！