MSAccess数据库超过2GB [英] MSAccess database over 2GB

问题描述

尊敬的先生，



i我使用MS-Access 2007（accdb）作为后端..前端是VB.net（windows应用程序），这是现在完成..

当我使用application..databse文件时，重量变为2GB ..

现在不允许保存更多数据..

现在我能做些什么..



请帮助我..我现在遇到麻烦..



谢谢..

解决方案

基本上，你搞砸了。您不能拥有超过2GB的单个Access 2007数据库。



您需要拆分数据库。请看这里： http://office.microsoft.com/en-us /access-help/access-2007-specifications-HA010030739.aspx [ ^ ]按照拆分数据库链接

或使用REAL数据库引擎，如SQL Server 。



SQL Server Express 2012是免费的，支持最大10GB的数据库。



你可以得到它这里 [ ^ ]。



你可以还可以使用Access中的向导将数据库迁移到SQL Server。



老实说，如果已确定应用程序要求，可以避免这种情况rrectly。

Respected sir,

i am using MS-Access 2007(accdb)as a back-end..front end is VB.net (windows application) which is finished now..
When i am using application..databse file's weight become 2GB..
now its not allowed to save further data..
now what can i do for this..

please help me..i am in trouble now..

thank you..

解决方案

Basically, you are screwed. You cannot have a single Access 2007 database that exceeds 2GB.

You need to split the database. Look here: http://office.microsoft.com/en-us/access-help/access-2007-specifications-HA010030739.aspx[^] Follow the "split a database" link

Or use a REAL database engine, such as SQL Server.

SQL Server Express 2012 is free and supports databases up to 10GB is size.

You can get it here[^].

You can also migrate your database to SQL Server using a wizard in Access.

Honestly, this could have been avoided had the apps requirements been identified correctly.

这篇关于MSAccess数据库超过2GB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！