Access Database Error

S

siyeducation

I have two databases on two different shared drives. One has never had any
issues with people entering data using various forms, and the reports
consolidates all the data from various forms.

The other one is a pain. It keeps getting corrupted. I have compacted and
repaired the database many times, backed it up, but it keeps getting
corrupted. The error states that the db is in an "inconsistent state". I
usually have to take a copy of the database and go to another machine that is
not part of the network and open the database and let it run the repairs.
Then I copy it back to the other folder location again for the staff to use
it...only to wait for another corruption.
 
J

Jerry Whittle

You need to check if the problem database comes through a different router or
switch. Also if it's on a different server or even hard drive.

Have you considered moving it to the 'good' drive?
 
J

John W. Vinson

I have two databases on two different shared drives. One has never had any
issues with people entering data using various forms, and the reports
consolidates all the data from various forms.

The other one is a pain. It keeps getting corrupted. I have compacted and
repaired the database many times, backed it up, but it keeps getting
corrupted. The error states that the db is in an "inconsistent state". I
usually have to take a copy of the database and go to another machine that is
not part of the network and open the database and let it run the repairs.
Then I copy it back to the other folder location again for the staff to use
it...only to wait for another corruption.

Dollars to donuts there is a bad NIC (Network Interface Card) on the machine
with this shared drive. Access pumps a LOT of data around, and is therefore
very sensitive to noisy networks; for example, connecting to an Access
database over a wireless network or a WAN is going to give you no end of
trouble like this.

Make sure that this machine's connection to the network is fast, stable and
squeaky clean, if possible; or find a better location.
 
W

woai13141314

siyeducation said:
I have two databases on two different shared drives. One has never had
any
issues with people entering data using various forms, and the reports
consolidates all the data from various forms.

The other one is a pain. It keeps getting corrupted. I have compacted
and
repaired the database many times, backed it up, but it keeps getting
corrupted. The error states that the db is in an "inconsistent state". I
usually have to take a copy of the database and go to another machine that
is
not part of the network and open the database and let it run the repairs.
Then I copy it back to the other folder location again for the staff to
use
it...only to wait for another corruption.
 
A

a a r o n . k e m p f

Access doesn't support multiple databases or multiple users

move to SQL Server
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top