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:
Jun 23, 2015 | Microsoft Access Computers & Internet
Mar 22, 2015 | Microsoft Office Equipment & Supplies
Feb 28, 2015 | Microsoft Office Access 2007 for PC
Feb 23, 2015 | Microsoft Access 2003 for PC
Feb 05, 2015 | Microsoft Office Professional 2007 Full...
Jan 11, 2015 | Microsoft Office Professional 2007 Full...
are some reasons which may damage your MS access database such as
virus infection, software crash, accidental shutdown of system,
unrecognized format of database, corruption of storage media etc.
These issues are easy to overcome by using third party software of
access database repair.you can try Kernel Access Database Recovery Software one of the best software in Data Recovery
For information you can visit here ...http://www.accessrecoverytool.net
Aug 23, 2010 | Microsoft Computers & Internet
Jul 15, 2009 | Microsoft Office Standard for PC
Nov 10, 2008 | Microsoft Office Outlook 2003 for PC
697 people viewed this question
Usually answered in minutes!