Solved

Scheduled compact and backup Access 2007 databases

Posted on 2010-09-01
5
454 Views
Last Modified: 2012-08-13
Could anyone recommend a good third-party app that will compact and backup all my Access databases on a nightly basis?
0
Comment
Question by:thutchinson
  • 2
  • 2
5 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 33576369
0
 
LVL 10

Assisted Solution

by:Luke Chung
Luke Chung earned 250 total points
ID: 33581114
Hi Scott,
Thanks for thinking of us. Unfortunately, you have two of our products mixed up -- or more likely, we don't explain the differences properly.
Total Access Admin monitors Access databases and lets you see who's going in and out of it in real time (and can compact a database after everyone is out) but it's not designed for continual, audited database compacts and backups.
Our Total Visual Agent product is designed for enterprise quality database administration of Access/Jet databases. It lets you manage an unlimited number of databases across your network. You can specify databases individually or just point to a drive or folder and tell it to manage all the *.ACCDB or *,MDB files in it and its subfolders.
You can schedule tasks like compact, backups, zipped backups, rolling backups, data extractions, collecting statistics, running a macro, running a command line, etc. Events can be scheduled hourly, daily, weekly, monthly or one time. It supports ACCDB and MDB database formats, including those with password and/or Access workgroup security.
Once you specify what you want it to do, Total Visual Agent can run as a standalone program or as an NT Service. The latter is particularly important in case the machine restarts since you can ensure Total Visual Agent also restarts.
If errors are encountered, Total Visual Agent can notify you via email. All events and tasks are audited (in an Access database) so you have documentation of your system administration processes.
More info here: http://www.fmsinc.com/MicrosoftAccess/Scheduler.html
A free demo is here: http://www.fmsinc.com/Products/Agent/conftrial.asp
Hope this helps.
0
 

Author Comment

by:thutchinson
ID: 33581274
Hi Luke Chung,
To be clear:  Since there is no run-time available then I will need to run it from a workstation and not the server, correct?  (Otherwise I would have to load Access on the Server)
0
 
LVL 84
ID: 33581412
Thanks for clearing that up Luke. Looks like Total Visual Agent would be the right product for this situation.

0
 
LVL 10

Expert Comment

by:Luke Chung
ID: 33581503
thutchinson.
Depends what you're doing but you are generally correct.
In order to have the ability to run Access macros, Access will need to be installed.
If you only want to compact databases, DAO will need to be installed. If you're dealing with ACCDBs, Access 2007 will need to be installed (could be the runtime).
Generally, a workstation works fine. If you're only dealing with a few databases that aren't massive, it doesn't need to be too high powered.
30 day free trial should let you see if it works for you.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question