Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 465
  • Last Modified:

Scheduled compact and backup Access 2007 databases

Could anyone recommend a good third-party app that will compact and backup all my Access databases on a nightly basis?
0
thutchinson
Asked:
thutchinson
  • 2
  • 2
2 Solutions
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
0
 
Luke ChungPresidentCommented:
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
 
thutchinsonAuthor Commented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Thanks for clearing that up Luke. Looks like Total Visual Agent would be the right product for this situation.

0
 
Luke ChungPresidentCommented:
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now