Spiceman said:
I am trying to understand how to figure out how and why a DB that was
working fine for years all of a sudden starts locking, and going in
to unrecognised format????
totally confused. I've jecomp'd the DB and have replaced hardware to
eliminate bad nics. Does anybody have an input or diagnostic tools I
should be utilizing to determine the problem?
You've partially eliminated one of the 2 main causes of problems. Checking
ALL this NICs including the ones on the router and server will assure you
that all is working properly. The other main cause of corruption is users or
machines who improperly exit the database. That can be a bad power supply,
video card, or even a hard drive. More often though, it is a user who simply
shuts down without exiting.
The best clues will come from the time of day. If it works fine all day and
is corrupt first thing in the morning, the chances that it is a user are
very high. Do you have a new user?
One other possibility is that your efforts at fixing the corruption have not
resulted in its elimination. Try importing all the data, one table at a time
into a new database. 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