Question Backup and Compact Button

[sujitagarwal]

Hey I have created a complex database on taking input from three ends and it includes around 20 Queries, 8 Reports and 5 Forms for specific operations.

There are two things I am still confused with:
1. How to add a Backup and Compact Database button on the Dashboard (i.e. the parent form)?
2. How to allow the user to edit a record by searching for an unique data in each table?

I am working on Access 2007 and wish to distribute this software bundled with Access 2007 installer file. I would avoid Access Runtime though it works fine, it does not gives me the backup utility.:banghead:

Can anyone help?

 

[Isskint]

Back up and compact.
Compact can be set to happen every time the DB is closed. In Access options select Current Database and tick Compact on close.
Backup is a different beast. Once the database is in the workplace, you should not need to back up the forms & reports or other object structures. This would suggest the users can change the objects (not a good idea). Data backup, yes that is always a good idea. The simplest option here is to use one of the Transfer functions. You can save the tables to a spreadsheet, another database etc. Generally I have a Backup database that mirrors the tables of my main database. Then use the TransferDatabase function to export each table. Set this up either in a macro or a VBA procedure. Both can be called from a command button. You can secure the Backup DB with an autoopen macro or Enter password opening form.