File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Access - run Compact and Repair from Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Access - run Compact and Repair from Java" Watch "Access - run Compact and Repair from Java" New topic

Access - run Compact and Repair from Java

Velika Srbija
Ranch Hand

Joined: Jan 15, 2002
Posts: 172
What way I should call menu item:
Tools/Database Utilities/Compact and Repair Database
in Access 2000 from my Java application?
William Brogden
Author and all-around good cowpoke

Joined: Mar 22, 2000
Posts: 13036
You would do a lot better in a JDBC related forum!
Kyle Brown
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
Absolutely. This doesn't belong here. I'm moving it to the JDBC forum.

Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at for other WebSphere information.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

I smell a cross poster
it is generally frowned upon to cross post. Choose most appropriate forum to post to, and post it once. If you have made the wrong choice, the forum moderator will move it to the most appropriate forum for you (as done by Kyle Brown) for no additional charge.

quoted from Dave Vick:
Thanks for posting your query here in the <jdbc> forum, however, please don't cross post your questions to multiple forums, most of the visitors here read in many of the forums and it is frustrating to see the same question repeated over and over - you have a better chance of gettng a correct and timely answer if you post it to the most appropriate forum instead of using the shotgun aproach and hoping you'll hit something.

as to the question, I'm sure that you can run the procedure using native code(probably converted from VB code using ADO), but through java, I don't think so. You also may be able to purchase some proprietary software/jdbc drivers to perform this functionality.

[ March 12, 2002: Message edited by: Jamie Robertson ]
I agree. Here's the link:
subject: Access - run Compact and Repair from Java
It's not a secret anymore!