How do I compact a backend database

[IceTy Mbatha]

Hi
I have an access database split into an application and a backend. How do I
compact the backend from within the application?

 

[Douglas J. Steele]

As long as the back-end isn't current in use, you can use the
CompactDatabase method of the DAO DBEngine object, or you can use JRO (see
http://support.microsoft.com/?id=230501 for details)

 

[IceTy Mbatha]

Thanks, I will look into that method.