Text Backup V1.11

$17.95

Most developers are familiar with having to rebuild an Access database to try and remove an elusive corruption. The undocumented functions SaveAsText and LoadFromText have been used to rebuild suspect databases for some time.

This can also be done by creating a new MDB and importing all the objects from the suspect database. However, this does not always work and corruptions persist

The SaveAsText and LoadFromText functions often fix problems that just don't go away with the import method mentioned above. The only problem with this is that you had to write your own solution to use these functions. Unless a great deal of time was spent on this, the solution was generally not that easy to use and designed to fix a particular problem.

The Text Backup add-in takes away all the frustration by providing a simple and easy to use interface for multi-selecting objects across all types - queries, forms, reports, macros and modules - for easy and quick backup to text files. Even save your References and Startup Options, and data.

Restoring those files is equally easy through a simple multi-selection of objects from the storage location for loading back into the current database.

This add-in will save you many hours of development if you are considering building a solution of your own using the SaveAsText and LoadFromText functions, and many hours of frustrating bug chasing when objects can easily be saved and restored in just a few simple steps.

The add-in is easily installed using the Access Add-In Manager. Once installed it is quickly accessed from the add-ins list.

Suitable Uses

Database Backup

You can easily create text copies of all your database objects. Regularly saving all your objects to text files ensures you have a recent version of the object to restore to in case something goes wrong.

Distribution of Objects

If you regularly send objects to other developers or co-workers, sending them as text is an excellent solution. By using the Text Backup add-in you can quickly select the relevant objects, back them up to text files then attach the files to an email for delivery.

Bug Resolution

When you have tried in vain to find that elusive bug, save the offending object as text, delete it from your database and then restore it back from the text file. Very often this will fix the problem by rebuilding the object completely.

Features

• Backup data, queries, forms, reports, macros, modules, references and startup options easily.
• Multi-select objects of different type and backup in one operation.
• Backup to any location desired. Easily selected through a file dialog.
• Restore objects individually or in selected groups from any location.

Important

Please make note that this Access application is supplied as an MDE file and is thus NOT editable in design mode. You cannot make design changes to objects such as forms, reports etc. If required, we can provide a service to customise the application to your needs. Do not purchase this application if you intended to make modifications yourself.

If you are interested in purchasing the source code to this application so you can make modifications then please contact us with details to obtain a purchase price.

Installation

Installation is very simple.

1. Extract the file TextBackup.mde from the self extracting ZIP file you downloaded to either the default location or one of your choice.
2. Open any Access database and use the Tools > Add-Ins > Add-In Manager option to display the Add-In Manager dialog.
3. Click on the Add New... button to display a file dialog. Locate and select the file you just extracted. Click on Open and that's it. The add-in is installed.

$17.95