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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|