Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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..
Posted
Updated 29-Mar-17 5:52am
Comments
Sunil Bansode 18-Apr-12 0:39am    
But at my customer's machine i have to installed SQL Server..
Is it required?

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
 
Share this answer
 
Comments
Sergey Alexandrovich Kryukov 17-Apr-12 11:51am    
I like when someone brings good news... :-) A 5.
--SA
VJ Reddy 17-Apr-12 20:17pm    
Nice answer. +5
Manoj Kumar Choubey 17-Apr-12 23:57pm    
Nice
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.
 
Share this answer
 
Comments
VJ Reddy 17-Apr-12 20:17pm    
Good advice. 5!
Manoj Kumar Choubey 17-Apr-12 23:57pm    
Nice
Sunil Bansode 18-Apr-12 0:38am    
But at my customer's machine i have to installed SQL Server..
Is it required?
Dave Kreskowiak 18-Apr-12 1:07am    
To use an SQL database? Yes! To use a database greater than 2GB? Yes!
It doesn't matter which edition of SQL Server, so long as it's not the Compact edition.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900