Avatar of exp vg
exp vg
 asked on

Access - Common db Corruption Causes

Can someone please advise on what some of the most common causes of a db corruption?

Thanks
Microsoft AccessVBA

Avatar of undefined
Last Comment
exp vg

8/22/2022 - Mon
Sylvain Drapeau

Sorry for the link dump, but no point in re-writing what has already been written :

Specific for MS Access : http://allenbrowne.com/ser-25-01.html

Hope this helps !
exp vg

ASKER
I read through - thank you for the link. Further clarification is appreciated on whether a db can be corrupt file - without realizing it - until final shut down - that may affect prior functionality without realizing it. That is - queries, macros, etc. - might not have been optimal for a file.

I do a lot of file transfer - so the origin may have begin with this.
Sylvain Drapeau

Do you mean if the DB can become corrupt while using it but you don't notice it until you close and open it again ?

About your last comment, if you copy a database while it's being used (the file is open), the copy might be corrupted because it wasn't synced, but the original should be ok, unless your copy operation force close it.
Your help has saved me hundreds of hours of internet surfing.
fblack61
exp vg

ASKER
Exactly - can it become corrupt while using it - so some of the results are flawed - but I did not realize this - until I could not open the db at all.

I do save versions - but none of them worked.

Thanks.
Jim Dettman (EE MVE)

@exp vg

Some common causes:

1. Using a JET/ACE database over a WAN - 95% of the time, a WAN does not meet the network needs for the database engine.

2. Using a JET/ACE database over a wireless connection - Wireless is subject to dropouts and high latency at times.

3. Open a JET/ACE database with something other than Access, like a word processor.

4. Anti-Virus software that scans and attempts a "fix" of the file.

5. Network issues - NIC's with bad drivers (not so common now), NIC's with diag or power modes that cause the NIC to disconnect from the network, bad cable, router, or switch, etc.

6. Inactivity timeout on mapped drives when a DB is accessed over a network.

Those are the most common.

Jim.
exp vg

ASKER
Thank you JIm. I am using a work computer - so I would think that a lot of protection issues are in place. However, I reached a point where I was not able to open the db - it initially hesitated while opening - but then I could not open this.

It seems corruption can happen even when there is a work computer.

To confirm - if the db had been corrupt for a while - is it possible that underlying queries/calculations were affected - but I was not aware.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Sylvain Drapeau

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jim Dettman (EE MVE)

<<To confirm - if the db had been corrupt for a while - is it possible that underlying queries/calculations were affected - but I was not aware. >>

 Possible, but not common.  Usually corruption causes things not to work and it is fairly obvious (you get errors).

 <<However, I reached a point where I was not able to open the db - it initially hesitated while opening - but then I could not open this.>>

 If this is a database in MDB format, you can try using JETCOMP.EXE, which is a standalone utility that does a compact and repair without opening the DB normally as Access would.

 To open a database, Access depends on the Database Header Page being sound.  If it's not, it will not be able to open the database.    JETCOMP.EXE does not try to log into the database, but works on it directly.

 A backup though is usually the best recovery.

Jim.
Jim Dettman (EE MVE)

<<@Jim Dettman : Thanks, and sorry about that.>>

 No problem at all.  Just something that EE has changed policy on and we are slowly spreading the word as it comes up.

Jim.
exp vg

ASKER
Thanks Jim

So - if I am using the db - that eventually became corrupt - will all the objects created in it be sound? I did get errors - but I took them as formatting errors in what I was creating - but from what you were telling me - this may have actually been a warning.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
SOLUTION
Dale Fye

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
exp vg

ASKER
Thanks Jim - this is what I have been seeing. I do not want to take up more of your time.

And unfortunately - what I have learned is that it does not matter if it is on a work computer either - which I thought would be more secure.
exp vg

ASKER
Thank you.