The Workbench is a program that will help you manage your Microsoft® Access® databases. The Workbench will prompt you to open the appropriate version of Microsoft Access 2007/2010/2003/2003. It will allow you to see the users/computers using your database, lock out new users so that you can do maintenance and has some very easy check boxes so that you can compact, compile, decompile and backup your database as databases or in zip format. You can easily switch between and organize your Access databases by storing them as favorites, make desktop shortcuts and rapidly switch between workgroup accounts. You can view and change the Startup Properties of your database in a few seconds as well as make an mde database without opening the database.
If you have a lot of users or trouble getting everyone to log off, you can use the new Administration tools that allow you to send messages to your users and even shutdown the databases. To do this you will need to add about 80 lines of visual basic code to a form in your database. The Workbench makes it easy to set this up if you are a programmer but if you are not, you will be provided with a database with some forms that you can import into your database. These forms will also help you with logging of Windows User IDs and also show you how to display release version information on the main form in your database. These demonstration databases comes with full Access source code and objects. Access 2007 support here
to download the Workbench installation software and help file (2.3 mbytes).
The software is downloaded as a zip file that you will unpack on your computer. You will need Microsoft Access 2010, 2007, 2003 or 2002 on your computer. Save the zip file to a new folder. Once downloaded, see the readme.txt file in the zip file for the installation instructions. Once installed, click the "Start" button, select "Programs" and choose the "vb123.com" group.
Learn how to install the software here
When you purchase the software, you will receive a registration code via email. This will activate the software that you have downloaded. You will be required to register the software after opening the workbench 50 times. Purchase the Workbench here.
Upgrades: If you have the free book version (1.3) of the workbench, you need to purchase a full copy of the workbench to run the latest version. If you have a previous version more than a year old, you will need to purchase an upgrade for $10. If you have purchased the software recently, we will notify you by email telling you how to download a free upgrade.
Vista, Windows 7 and Access 2007
Power Users, Developers
Download the latest (no setup.exe) version This download is only a 600k but you sometimes need to have installed the production version (doesn't matter which one and it doesn't need to be registered). This version can be tested and will not overwrite the production version until you save it in the C:\program files\vb123\ folder.
Most Recent Improvements
More Comprehensive Backups
Internal User Logging and Release Version Management (For Registered Users)
Included with the registered version of the Workbench is internal Access logging software. This allows you to keep track of who is opening the database and what objects they are using. You can then identify the actual NT/Win 2000/Win XP usernames and even log them off the system at a certain time. This is a different approach to the Workbench that will also assist in management of your Access users. The download database also shows you how to display the release version of database from a table, a system supported by the workbench. Read more
Click here to download a trial version of the User logging Software in Access MDE format. All Access versions supplied and sample reports in PDF also included. We send these unprotected MDB databases out when we process the order (Australian business hours).
We love coming up with ideas but we would rather have your suggestions. Click Here to email your suggestions to Garry and his team.