Most Valuable Professional


subscribe to rss feed
Subscribe in a reader

Home > English site > Downloads > Downloads For Access
Deze pagina in het Nederlands

downloads 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: 1519 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 and 2007.

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 24 in total (Show All Comments):

 


Comment by: Elizabeth (8/25/2009 11:58:44 AM)

Love this tool but I'd like to know if there an easy edit to the ModBackup code to replace existing file instead of putting the word copy after it and keping the old file. reason i ask is i am using this to copy my master database from a network location that only I have full access for to another network folder where the users only have view access. I already have a network backup that runs every night. I mainly wanted to use this tool to save me some time in copying/pasting the various databases from their various master folders to the viewing folder.

Thanks

Elizabeth

 


Comment by: Jan Karel Pieterse (9/7/2009 9:58:16 AM)

Hi Elizabeth,

You'd have to edit these lines in the sub called ExportTables in module modBackup:

        On Error Resume Next
        'we keep two copies of the backup, just to be on the safe side
        Kill sFileName & "(copy 2)"
        Name sFileName & "(copy 1)" As sFileName & "(copy 2)"
        Kill sFileName & "(copy 1)"
        Name sFileName As sFileName & "(copy 1)"


Change them to:

    Kill sFileName

 


Comment by: Frank Yan (9/26/2009 8:11:03 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,macro,moudules 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 (9/27/2009 1:59:20 AM)

Hi Frank,

Indeed the tool does not do that. In general it is advised to keep data and logic of a database application separated: All data in a back-end database and everything else (reports, forms, queries, VBA) in a front-end database.
This tool is aimed at saving the back-end, as that is where the data is. The frontend is mostly relatively static and hance does not need much backups, only when a change has been made.

 


Comment by: Robert (11/4/2009 3:27:05 AM)

Love the tool is very helpful. but does this form need to be open so that it can save a backup? also can more then one person have the form open as it is backing up the files?
as when i have it close it does not save a backup.

thanks

 


Comment by: Jan Karel Pieterse (11/4/2009 6:41:24 AM)

Hi Robert,

Indeed, the form needs to be open as long as you want it to create backup copies. I think having the tool open on two systems may not be wise. The tool might start the backup process on two separate machines at the same time. This will slow down your database considerably.

 


Comment by: Julia (2/2/2010 11:40:30 AM)

Jan,

Thanks for this tool - it's a life saver! I do have one question for you.

I'm pointing the tool to one particular Access 2007 database with four LINKED tables attached to it. (All other supporting tables within it are LOCAL.) The tool seems to choke because of those LINKED tables (located on same server but different directory/folder). I get the following error message:

Error Number: 3011
Error Source: listTable
Error Description: The Microsoft Office Access database engine could not find the opject '(table name)'. Make sure the object exists and that you spell its name and the path name correctly.

Will your tool not backup a database with linked tables or am I doing something wrong?

Thanks!

 


Comment by: Jan Karel Pieterse (2/3/2010 12:03:05 AM)

Hi Julia,

I have updated the tool so it ignores linked tables.

 


Have a question, comment or suggestion? Then please use this form.

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.