Here are four quick tips I use to keep my database file size down and my queries running quickly. These have been gleaned from various articles I've read over the last few years. You'll want to follow these in order to ensure each step benefits from the one before it. If you have any more, add them in the comments section.
backup
Updated VBA Backup code
I've updated the backup code I presented in a previous post: A VBA Based Backup Solution
In addition to the existing function, this code will make copies of open files (of any type). So if you wanted to backup the currently open workbook, you can do that now. Or that .ppt file with next week's presentation, and so on. I've added better error handling as well. Below you will find the main procedure, along with all of the ancillary functions (except for BrowseForFolder which you'll need to get at VBA Express).
A VBA-Based Backup Solution
Problem: You need an easy way to backup an important file on a regular basis. Copying and pasting the file to another folder (with Windows Explorer or some other folder browsing tool), or saving it twice (once to its current folder, and again to a backup folder) is tedious, and still requires you to manually indicate file version.
Solution: Use this Excel VBA procedure. It can be used to backup any single file to a folder of your choice, appending a timestamp to the filename for easy rollback and version management.
Follow Me