Access Database Error

  • Thread starter Thread starter siyeducation
  • Start date Start date
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.
 
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?
 
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.
Click to expand...

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.
 
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.
Click to expand...
 
Access doesn't support multiple databases or multiple users

move to SQL Server
 
Back
Top