Attachment Manager
It is common practice for application developers to keep data tables in a separate .MDB file from the program. This technique is called having a front end/back end application. The Attachment Manager can help you easily organize, maintain and update attached data links. Managing these links can be somewhat tedious, especially if you have many tables and more than one data file to which the tables are linked. You are not limited to one data source, so tables could come from several different sources. You may also sometimes lose the links if the data source you are linked to is not available. In this case it may be necessary to refresh your links. In addition, it is not uncommon to want to relink to different data files. This could happen if you have a different set of data files for multiple companies or different projects.

The EZ Attachment Manager is self-contained and handles the functions and interfacing requirements for managing linked tables in an application. There are several modes available with the Attachment Manager depending on the user and the application.

The goal in the design of the Attachment Manager was to make it easy to use for both the end user and the developer. Depending on the application and how the Attachment Manager is set up, the user can be presented with one of several different interfaces. The functionality of each interface depends on how the link information is stored. It can be stored within the source tables only or within both with the source tables and in a special table designed to work with the Attachment Manager.

The Simple End User interface is a simple interface that only requires the user to choose the file attachment location. The Attachment Manager form will display a form with a label describing the category of the various file locations.

Archive Manager
Create or maintain a separate data file for archived records. Includes a user interface to handle copying records to the archive and deleting archived records from the active data file. Record selection is done via set of SQL statements stored in a table.

File Utilities
This interface provides a ready-to-go form to do backups, file repair, file compression, compiling, and file upgrading. Upgrading is done by a table of append query statements.

Is Compiled
A form called by your application that will only open if your database needs to be compiled. The form displays an option for the user to compile the database.

Compare/Patch Manager
This interface can compare two MDB files to see the changes in the objects then create a MDB file that contains the latest version of the objects that are different along with an installer to install the patches.

Patch Installer
This interface is saved in the file created by the Patch Manager and is a user interface to select the file to update and then copy the new or changed objects to the file and delete the old objects.

EZ File Manager is part of the EZ Developers Suite

System Requirements:
Access 97, 2000 or 2002
Runs on Windows 95/98/2000/ME/XP, Windows NT 4