Solved

Scheduled compact and backup Access 2007 databases

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
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 …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

735 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