Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Downloads > Downloads For Access
Deze pagina in het Nederlands

downloads for Microsoft Access

On this page you will find tools I created for Microsoft Access.

Donations

Do you like any of these tools? 

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: 10,008 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:

Credits: Thanks to Paul Connolly for adding the relationships code.

Works for Access 2000, XP, 2003, 2007 and 2010.

Access backup tool progress window

Progress window of backup tool.

Settings window of backup tool

Settings window of backup tool

Click here to request support or issue comments or suggestions on this product.


Comments

Showing last 8 comments of 109 in total (Show All Comments):

 


Comment by: Sonam Dhendup (10/1/2015 7:09:24 AM)

Hello Sir/Madam:
I'm very glad to find this software as backup access automaticly for your website,It's very useful for me.
But I find the question for this software that it only export the Table part when it execute backup action.
I'm want have the software that it can export the whole database such as table,queries,forms,reports, macro and moudule when it's export as backup file. Is it possible?
Would you like to give me this kind of founction softeware and I will be appreciate your strong support!
Best Reagard!
Frank

 


Comment by: Jan Karel Pieterse (10/1/2015 11:19:16 AM)

Hi Sonam,

The tool is intended for back-end/front-end MSAccess solutions, where the front-end is a more or less static database that contains all your logic (forms, reports, queries, VBA code) and your back-end contains just the tables (and hence all data) and their relationships.

The tool assumes you already have a backup copy of your front-end database.

 


Comment by: Georg (10/8/2015 10:03:02 PM)

Hello I downloaded this tool and it works great with Access 2007 but not with Access 2007 Runtime.
Can you imagine a reason?
Thanks, Georg

 


Comment by: Jan Karel Pieterse (10/9/2015 1:35:11 PM)

Hi Georg,

TBH, we've never tried the tool in Access runtime :-)

 


Comment by: Giorgio (10/24/2015 1:13:53 PM)

Hi, I want to save even a folder with the BMP files, it is possible?

Thank you

 


Comment by: S Fernando (3/16/2016 12:10:29 PM)

How can I automate this back if the access file is protected by a password.

 


Comment by: Sultan (10/17/2016 12:48:22 AM)

Hi thanks for your database its really very useful but it have a problem with that if Back-end protected with password when click on backup it say enter password and then when entering the password just stock and not complete backup process


please tell us how to solve this issues

 


Comment by: Jan Karel Pieterse (10/17/2016 9:44:08 AM)

Hi Sultan,

I'm sorry, I haven't got time to suggest a fix for that problem now.

 


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.

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.