Access Database Error

[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.

 

[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?

 

[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.

 

[woai13141314]

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 r o n . k e m p f]

Access doesn't support multiple databases or multiple users

move to SQL Server