Hi,

is it possible to compact the current database from the vb code in the module? is manually clicking : tools, database utilities, compact and repair database - the only way to compact the current database ?

i understand that there is a compactrepair method. However this does not apply to the current database. This method can only be used from outside the current database.

:)

Check this out:

http://www.mvps.org/access/general/gen0013.htm

Kenny Alligood

view this thread

http://p2p.wrox.com/topic.asp?TOPIC_ID=5188

you also need to decompile as mentioned in the thread



Sal