A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Auto generated backups - delete?



 
 
Thread Tools Display Modes
  #1  
Old April 20th, 2010, 04:48 AM posted to microsoft.public.access.gettingstarted
Rachel
external usenet poster
 
Posts: 187
Default Auto generated backups - delete?

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
Ads
  #2  
Old April 20th, 2010, 05:43 AM posted to microsoft.public.access.gettingstarted
Richard
external usenet poster
 
Posts: 1,419
Default Auto generated backups - delete?

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
  #3  
Old April 20th, 2010, 01:46 PM posted to microsoft.public.access.gettingstarted
John Spencer
external usenet poster
 
Posts: 7,815
Default Auto generated backups - delete?

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

Rachel wrote:
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

  #4  
Old April 21st, 2010, 03:46 PM posted to microsoft.public.access.gettingstarted
Rachel
external usenet poster
 
Posts: 187
Default Auto generated backups - delete?

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

"John Spencer" wrote:

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

Rachel wrote:
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

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.