A Microsoft Access database is a complex object that is subjected to much stress in network environments and by programming. As a result you need backups of your work. In this article I will show you the
Application.SaveAsText and Application.LoadFromText methods
to save and then recover queries, forms, reports, macros and modules. To do this you will export all objects to text files in a sub folder using code that I will provide you. Then you copy and paste some vba code that will be autogenerated and use that to populate an empty database with all your newly exported objects.
This whole process can also help you diagnose and sometimes help you recover an already corrupted database.
It will take you less than a quarter of an hour once you get the hang of it. Read the article here
A Happy New Year to all of you.
MS Access MVP 2006 - 2012