[AccessD] Best way to fix database

Backups? I've heard of those. I get religion after every disaster (Oh God I
promise to backup every day if you'll just let me slip by this one time...)
but I inevitably fall back into my slothful ways. :-)
Jim Hale

-----Original Message-----
From: Heenan, Lambert [mailto:Lambert.Heenan at aig.com]
Sent: Tuesday, November 08, 2005 1:06 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Best way to fix database


Number 1 on the list should always be "Make a backup copy of the mdb"

Then...
compact and repair
Still not good?... Decompile (not officially supported, so make sure you
backup)

If neither of the above fixes the problem try  using JetComp to compact the
database.

Still no luck? Import everything into a new database.

If you think you know that a specific code module is causing the problem
then try this.


Open the module and comment out all the code lines
Save the module
Compact and repair
Compile
Open the module again and uncomment all the code lines
Save the module
Compact and repair
Compile
Compact and repair.

HTH

Lambert


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Tuesday, November 08, 2005 1:52 PM
To: 'Accessd (E-mail)
Subject: [AccessD] Best way to fix database


Is this the correct order of operations to fix a flaky mdb? I can't remember
what order works best.

decompile
compile
save
compact and repair
import to new container

TIA
Jim Hale

***********************************************************************
The information transmitted is intended solely for the individual or entity
to which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of or
taking action in reliance upon this information by persons or entities other
than the intended recipient is prohibited. If you have received this email
in error please contact the sender and delete the material from any
computer. As a recipient of this email, you are responsible for screening
its contents and the contents of any attachments for the presence of
viruses. No liability is accepted for any damages caused by any virus
transmitted by this email.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.