Inconsisitant state

  • Thread starter Thread starter Lovespar
  • Start date Start date
L

Lovespar

;I have a small dB that when on my personal drive at work works great and
opens quickly. then I had to move it to the Network drive and every time we
open it I get an error statement that says it is in an "inconsisitant state"
and a repair table is being created. Well, I never find the repair table so I
can fix why I keep getting this error.
Any ideas?
 
You are most likely getting because you have a corrupt file. Front-ends eun
from the network sometimes corrupt because multiple people are trying to use
them at once. You need to fix the corruption, then split the database, and
put ONLY the data back-end on the network. The front-end must run from each
workstation. To fix the corruption:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
 
Thanks,
the reason I have this dB is that is was corrupt and I fixed it, then put it
back out there. No one has access to that folder but 3 people. I will go
through these steps
and see if I can figure out why it keeps corrupting. This has to be
accessible to people in differnt locations so I can't load the FE on
individual machines. Does it make any since to split it if the FE is in the
Same folder as the BE?
 
Back
Top