Solved

Scheduled compact and backup Access 2007 databases

Posted on 2010-09-01
5
449 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

786 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