There are two methods for compacting the database. Method one uses the standard compact utility built into Access 97 and 2000. Method two uses the JetComp utility.

Method one:
1) Verify there are no users in the program
2) Open the full version of Access
3) Hit "Cancel" on the "Open Database" window
4) Click on "Tools," then "Database Utilities," then "Compact Database"
5) Locate ClientsT981.mdb through the "Locate" window
6) Click on ClientsT981.mdb, then on "Compact"
7) Choose new database name to compact in, then click on "Compact"
8) When compacting is finished, close Access, open Windows Explorer
9) Go to database location on server, rename ClientsT981.mdb to oldClientsT981.mdb, rename compacted database to ClientsT981.mdb

Method two:
1) Verify there are no users in the program
2) Double-click on jetcomp.exe (the JetComp utility)
3) Click on button with three periods next to "Database to compact from"
4) Locate the ClientsT981.mdb through the "Locate" window
5) Highlight source database path, then hit ctrl-c
6) Place cursor into destination blank, then hit ctrl-v
7) Change the database name in the destination blank
8) Hit "Compact"
9) When finished, close JetComp, open Windows Explorer
10) Go to database location on server, rename ClientsT981.mdb to oldClientsT981.mdb, rename compacted database to ClientsT981.mdb

HELP!!! My database popped up an error message during the compact that says "Records can't be read: No read permissions". Approximately 95% of the time, there is not much to worry about. If you open Windows Explorer, then go to the location of the database you just compacted there will be a db1.mdb file. Try to open the db1, if you can, then can just perform the renaming step from above. If you can't, then you have a larger problem. At this point, contact Kemp's Case Works.

NOTE FROM MICROSOFT: Jetcomp.exe is a stand-alone utility that allows you to compact databases created with Microsoft Jet database engine. This utility may be used in conjunction with Microsoft Jet database engine for recovering corrupted databases. Although it is possible to use the Microsoft Access Compact / Repair utility or the CompactDatabase method with Microsoft Jet database engine, Jetcomp.exe may be able to recover some databases that these utilities could not. This is because the Microsoft Access Compact / Repair utility and the CompactDatabase method attempt to open and close a database before attempting to compact it. In certain cases where these utilities may not be able to reopen the database, Compact will be unable to proceed, preventing recovery of the database. Jetcomp.exe does not attempt to open and close the database before compacting, and may be able to recover some databases that the Microsoft Access Compact / Repair utility and the CompactDatabase method could not.

Copyright © 2002 All rights reserved Kemp's Case Works, Inc.