TCS - Access Sig Report

Access Sig Report

by Don Singleton
Tulsa Computer Society
From the August 1997 issue of the I/O Port Newsletter

At the May meeting of the Access Sig Jenny brought up a problem she was having at one of her clients where the database was so big that it took six hours to repair and compact the database, something which needs to be done periodically, both the keep the database as small as possible, and to fix any minor problems before they become major. What she needed was a way to automate the process.

At the June meeting two solutions were provided. Richard DeJongh brought in a fixmdb.mbd utility that works with Access 2 that he found on the Access Forum on CompuServe, and Jennifer McNamara brought in a solution she found in an Access Newsletter by Cobb, and versions of that solution for Access 2, Access 7 (from Office 95), and Access 8 (from Office 97) are available on the Cobb FTP site:

Access 2ftp.cobb.com/ima/June97/AUTOREPR.MDB
Access 7ftp.cobb.com/ima/June97/AUTO95.mdb
Access 8ftp.cobb.com/ima/June97/AUTO97.mdb

If you are going to get these files with ftp by going to the ftp.cobb.com, and working your way down directory by directory, or by clicking on one of the links from the web version of this article, you don't need to worry about case, but if you are going to key this in directly, either in a browser or in a command line ftp, be sure to follow the use of upper case and lower case letters exactly, because Unix is case sensitive, and they were somewhat inconsistent in the use of case in naming these three files.



For more information on the Tulsa Computer Society click here


This page has been accessed times.
Tulsa Computer Society 07/07/97
Don Singleton, President
tcs@galstar.com