Solved

Scheduled compact and backup Access 2007 databases

Posted on 2010-09-01
5
458 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 85

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 85
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

630 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