WWW This site

Application Development

---

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:



Change them to:

 

---

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].