Auto generated backups - delete?

  • Thread starter Thread starter Rachel
  • Start date Start date
R

Rachel

A few times now my database has closed itself due to error and create a
backup. Each time I saved the backups I've added a number eg 1, 2, 3, 4 so it
would allow me to save.
Now I have 6 backup files from over the last few weeks.
Do I need to keep them all? Or just the most recent one?
How can I get the back up file just to refresh itself rather than having to
create a new one each time. (as this takes up a lot of space).
Any suggestions or explanations would be a great thanks!
Rache
 
Rachel

This could be a Microsoft Access Lock File, check the File extension: .LDB
When something goes wrong with your database one is created. Most of the time
I delete them.

Richard
 
One, you can't get the backup to just refresh itself. IF you are satisfied
that the latest backup is good, you could delete one of the older backups.

It might be a good idea to copy the backup to some offline storage media such
as a CD. Then you will have a copy you can revert to.

If you are not making design changes to your database and this is happening,
you might consider rebuilding the database. It could be that there is some
minor corruption in the database.

From: Allen Browne
Okay, so something has gone haywire with this database. Suggestions to recover it:

1. Make a backup copy of the mdb file, without overwriting any existing
backups, in case something goes wrong.

2. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect Explanation of why:
http://allenbrowne.com/bug-03.html

3. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

4. If the tables are attached, open the data file, and repeat steps 1 - 3 for
that file as well.

5. Close Access. Decompile the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

6. Open Access, and compact again.

7. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

8. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

9. Compact again.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, and reference ambiguities are resolved.

If it is still a problem, the next step would be to get Access to rebuild the
database for you. Follow the steps for the first symptom in this article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
John and Richard - Thanks so much for your in depth replies, I am completely
clear now on what I have to do.
Very much appreciated.

Rachel
 
Back
Top