Subscribe in a readerdownloads for Microsoft Access
On this page you will find tools I created for Microsoft® Access®.
Donations
The files
Unless stated otherwise, the downloads listed on this page are free of charge.
Use at your own risk.
Back-end Backup Tool
backuptool.zip (Build 004, 03 Feb 2010, 77k, Downloaded: 4672 times)Do you have one or more split Access database systems which are permanently in use? Then you probably know you can't just copy their back-end files to create a backup of them as the copies might become corrupt. This database tool allows you to make scheduled backups for an unlimited amount of Access databases. The tool keeps three backup copies of each database it backs up.
Updated to build 004:
- Also copies the relationships to the backup copy.
- Skips linked tables
Credits: Thanks to Paul Connolly for adding the relationships code.
Works for Access 2000, XP, 2003, 2007 and 2010.
Progress window of backup tool.
Settings window of backup tool
Click here to request support or issue comments or suggestions on this product.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Comments
Showing last 8 comments of 68 in total (Show All Comments):Comment by: M. Dunnlap (10/11/2011 8:55:54 AM)Thank you for this tool ... at first it was working perfectly ... but since i have changed my windows password when ever i try to run the program it prompts for a "data source" to be entered ... any ideas on how to remove this prompt??
thank you,
M. Dunnlap
Comment by: Jan Karel Pieterse (10/12/2011 12:05:37 AM)Hi M.
I'm not sure what is going on here! The program is self-contained, it has no linked tables, so it should not pronpt for anything as far as I know. Can you email me a screenshot?
Comment by: M. Dunnlap (10/25/2011 10:03:25 AM)my apologies for not responding ... i will send over that screen shot later this evening (EST) when i get off work ...
thank you for your patience ...
Comment by: Joe Z (11/16/2011 3:20:35 PM)Hello,
I have a little problem with the database. It works fine with 8 of my 2010 databases, but I have one that is password protected. When the backup ran last nite, it hung waiting for me to enter the database password. Is there any way I can have the database on the table and when the backup runs, it looks for the password on the table?
Thank You,
Joe
Comment by: Jan Karel Pieterse (11/16/2011 10:58:23 PM)Hi Joe,
I'm too tied up at the moment to modify the code, but you're welcome to adjus tthe tool yourself of course. You could use code mentioned here to open a password protected database:
http://msdn.microsoft.com/en-us/library/aa141813(v=office.10).aspx
Comment by: Joel (12/12/2011 9:02:15 AM)I'd like to backup the other modules in a database with the tables. Do you have a version of the Backup Tool that does this?
Comment by: Jan Karel Pieterse (12/12/2011 10:46:49 AM)Hi Joel,
You mean VBA code modules?
The tool is aimed at frontend-backend databases, where code is in the frontend database (not needing a save) and just tables and relationships are in the backend database.
Comment by: celmira (2/2/2012 7:44:41 AM)Exxxcelente.
It was working perfectly , thank so much.
Do you have something about "linked table" that made this process automatic?
Have a question, comment or suggestion? Then please use this form.
If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.