Question about Computers & Internet

3 Answers

Access 2000 database won't compact and repair.

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?

Thanks

Posted by on

3 Answers

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

  • Contributor
  • 3 Answers

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

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Champion:

    An expert who has answered 200 questions.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 401 Answers

It must be access database corrupted, make use Access Repair Toolbox software supports ms access databases starting with MS Access 97 version program

Posted on Jun 23, 2012

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 16 Answers

Mchampion,

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.

ArthurB

Posted on Apr 24, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Recently I had replaced one of HDD of my DL580 service Raid 5 configuration. After that everything working fine including user connectivity and database access. My question is both the LEDs on replace


After you replaced the drive, did you rebuild the RAID array? Some of the higher end RAID controllers will try to rebuild automatically (if set to do so) but most must be rebuilt manually.

Dec 22, 2014 | HP ProLiant DL580 G5 (438087-001) Server

1 Answer

TFT-5600 RKM Trackball not fully functional


Trackball? Think on these computers that there should be a small ring around the outside of the trackball. This ring turns? quarter or half turn then you can remove it and gain access to the inside rollers where the ball sits. Clean the rollers out and then put it back together and ytou should be good for a few more months. then just repeat when the problem gets to bad. Remember this is all "I THINK" Hard to remember back that far.

Dec 15, 2012 | Compaq TFT 5600 RKM - 15 w/ Keyboard,...

1 Answer

My server poweredge 1800 failed how can i remove data? and the server was configured raid 5


The obvious is to repair it, but if you have another identical server you can place drives and access data. The replacement should boot as failed server. Make sure to track drives and slot location. Shuffling may cause major failure. It may want to stripe itself again and cause data loss and defeating the purpose.

Aug 31, 2012 | Dell PowerEdge 1800 Server

1 Answer

Can not setup RAID 1 on an IBM X3200 M3 Server


you can access the raid controller using the BIOS and system devices>>> refresh>>> then select the controller then create your raid...

don't know why they move out from the POST the controller its really stupid''' Sorry..

Feb 04, 2012 | IBM System x3200 M3 7328 Server tower ...

2 Answers

Where can i download raid drivers for my caliber xn9010?


The driver you need is based on your raid controller on your motherboard or if you have one your raid card, so you need to determine the motherboard manufacturer or raid card manufacturer and get the chipset drivers from their website.

djbr1ck

May 12, 2011 | Cybertron Caliber XN9010 Server

1 Answer

If i wanted to set up a 300 workstation how many servers would i need


for what? Email? databases? web access? File and Print servers? Proxy server? Backup? Terminal server? If you're just talking about a domain with no applications, I suggest using 2 domain controllers for resilience.

Mar 30, 2010 | Dell Computers & Internet

1 Answer

Upgrading from 2003 access database to 2007


I would leave your database as Access 2003. the 2007 version has many bugs and will give you many more problems than its worth. Access 2003 is very stable, you should be able to keep it at that for many years.

Apr 22, 2008 | Microsoft Computers & Internet

1 Answer

How to limit remote access to a Termional Server


The best way to do this that I've found is to restrict the access via your firewall. Typically, Terminal server is listening on port 3389. So you would create rules in your firewall that will block any traffic to this port from IP addresses or subnets that you don't trust. While you're at it, you should shut down all other ports to everyone if you're not using them.

Mar 27, 2008 | Dell PowerEdge 1550 Server

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

697 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

98879 Answers

David Payne
David Payne

Level 3 Expert

14089 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...