How to reduce access'97 database size?
S Steve R Jul 13, 2005 #3 If you create and delete a lot of records in your database, you need to compact often. If you have trouble compacting, try this: http://www.matpie.drw.net/PBSystems/products/retired/MDBRepair.html There's a sample here to show how to do it with VBA. Make sure you get the correct sample. http://www.rogersaccesslibrary.com/download3.asp?SampleName=CompactDatabase.mdb
If you create and delete a lot of records in your database, you need to compact often. If you have trouble compacting, try this: http://www.matpie.drw.net/PBSystems/products/retired/MDBRepair.html There's a sample here to show how to do it with VBA. Make sure you get the correct sample. http://www.rogersaccesslibrary.com/download3.asp?SampleName=CompactDatabase.mdb