Browse...find...compact Possible?

[JWCrosby]

I've gotten the browse api working so users can browse to the proper file and
link its tables to the front end.

The "Compact and Repair" option only compacts and repairs the front end
program. What I'd like to be able to do is to have the user browse to the
file with the linked tables in it, and then have THAT file compacted and
repaired (since that's the file that gets bloated over time moreso than the
front end).

How would I do that?

thanks in advance

Jerry

 

[Douglas J Steele]

Look at the CompactDatabase method of the DAO Database object
(http://support.microsoft.com/?id=158937 shows an example of using it)

Other alternatives are to use JRO (Jet and Replication Objects), as
illustrated in http://support.microsoft.com/?id=230501, or JetComp.exe
(http://support.microsoft.com/?id=273956)