Question about Computers & Internet
My access database has reached the 2 GB limit and will no longer compact and repair. It is a major database for our company and we will be out of business without it. Is there any way to repair this?
User friendly interface which allows technical as well as non-technical users to easily work with the tool. The software is capable to restore queries, reports, forms, tables, macros and all other object of access database (.accdb or .mdb) file.
Go through Access File Recovery
Posted on Mar 21, 2016
You are in luck. I had the same problem a while back. Most of the time you will not be able to compact and repair a database that has reached capacity, however, you can import the database into a new one. The first thing you are going to have to do is find a very large table in your database and copy it into a new one. Then, delete that table from your old database. Now, open another new database. Go to the file menu and choose import. Now you must find your database in the directory and click it. Now choose one of the given options (tables, queries, etc.). Then, Press control + a to select all items. Now hit okay and it will import all of the items from your old database from that section into the new one. You must do this for each section (tables, queries, etc.). When everything is imported (should take less than an hour), compact and repar the new database. This will give you additional space to work with. Now you can bring in the table that you copied into a new database earlier the same way (import). This should put you back in business.
I suggest creating a 2nd database for any other data you may want to add later. You can always make link tables and such in your old database in order to get the additional data and prevent crashing your old database.
Let me know if you need any additional help.
Posted on Apr 24, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Apr 25, 2016 | IBM System x3400 7975 - Quad-Core Xeon...
Dec 22, 2014 | HP ProLiant DL580 G5 (438087-001) Server
Dec 15, 2012 | Compaq TFT 5600 RKM - 15 w/ Keyboard,...
Aug 31, 2012 | Dell PowerEdge 1800 Server
Feb 04, 2012 | IBM System x3200 M3 7328 Server tower ...
May 12, 2011 | Cybertron Caliber XN9010 Server
Mar 30, 2010 | Dell Computers & Internet
Apr 23, 2009 | HP Compaq Proliant DL350 (345101-001)...
Apr 22, 2008 | Microsoft Computers & Internet
Mar 27, 2008 | Dell PowerEdge 1550 Server
697 people viewed this question
Usually answered in minutes!