MSAccess数据库超过2GB [英] MSAccess database over 2GB
本文介绍了MSAccess数据库超过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屋!
查看全文