Compact Database

[Rohit Thomas]

Hello All,

Would any know if there is any sample code out there that
would replicate the same function avilable under
the "Tools>Database Utilites" menu to compact a multiuser
database? I would like to compact a database after a large
import has been completed.

Thanks,
Rohit Thomas

 

[Wayne Morgan]

Here are links to some examples you may find helpful.


http://www.mvps.org/access/general/gen0013.htm
http://www.mvps.org/access/modules/mdl0030.htm
http://www.rogersaccesslibrary.com/download3.asp?SampleName=CompactBackEndDB.mdb
http://www.rogersaccesslibrary.com/download3.asp?SampleName=CompactDatabase.mdb