Agee Software, Inc.

Framework Database

Click Contact, Report, Setup Options or Quit.

The Blank Database Template is a framework for rapid application development in Microsoft Access. It includes user level security, Main and Report menus, Setup form for global settings, Combo form for simple one or two field tables, Data Integrity form to spot and fix inconsistent data and a User form. You can force users out of database with a warning within three minutes for maintenance or to backup and compact the database. Although the database is secured by Microsoft Access User Level Security, authorized users can create an HTML data dictionary and view or export raw table data. You can change the link to other table databases. This lets you have a database for training, archives or an offline database for your laptop in a different location than your networked production database. This feature also lets you peek into a backup before you restore it.

By using this framework and copying modifying single record forms, continuous forms and reports, Agee Software is able to create a complete custom built application in a fraction of the time taken by other developers.

The Main menu shows the version number of the database. Click on the version number to see where tables are linked and other troubleshooting and contact information. Buttons have underlined hotkeys so Alt-R opens the Report form like clicking the Report button. Alt-Z from the main menu lets a super user make programmed table structure changes without having a developer log onto their network. Only one user has to make these changes. Other users should be out of the database when table structure changes are being made.

To install, map the path to the shared data, copy two files and open one of them to create a desktop shortcut.

To customize the shortcut to a specific user, right-click and select Properties. Change user in the far right of the Target to the user's userid. You may need to enable macros to avoid security warnings.

Updates are normally performed by sending a link to you via email with a summary of the changes. Follow the link and unzip the file onto your server in the same folder where your data tables are located. Double click on the database to create a shortcut. A super user should then run the new version on the server. Answer Yes when asked if you want to tell others the new version is available. When other users log into the database, they will be offered the new version. If they answer Yes, the database will close and they can reopen the database in about 20 seconds when the copy operation is complete. This update process also distributes the MDW file, where encrypted user accounts are stored, so any user can log in from any PC.

Here are several options that have been added to customize the framework.