Prev: Stopping or Restarting an Access App From Command Line
Next: Uppercase notation in access 2007
From: siyeducation on 10 May 2010 13:43
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.
From: Jerry Whittle on 10 May 2010 14:16
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?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"siyeducation" wrote:

> 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.
From: John W. Vinson on 10 May 2010 18:27
On Mon, 10 May 2010 10:43:01 -0700, siyeducation
<siyeducation(a)discussions.microsoft.com> wrote:

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

John W. Vinson [MVP]
From: woai13141314 on 11 May 2010 06:57


"siyeducation" <siyeducation(a)discussions.microsoft.com> 写入消息
news:272A247A-B65F-4DC0-89A1-91A2E2111819(a)microsoft.com...
> 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.

From: a a r o n . k e m p f on 12 May 2010 03:23
Access doesn't support multiple databases or multiple users

move to SQL Server




On May 10, 10:43 am, siyeducation
<siyeducat...(a)discussions.microsoft.com> wrote:
> 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.

 | 
Pages: 1
Prev: Stopping or Restarting an Access App From Command Line
Next: Uppercase notation in access 2007