It is best to just compact and repair outside of the app in question. I posted a class to do this here:

http://www.vbforums.com/showthread.p...hreadid=280667