File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Access - run Compact and Repair from Java" Watch "Access - run Compact and Repair from Java" New topic
Author

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
Rancher

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

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


Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

I smell a cross poster
http://www.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=3&t=002429
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.

Jamie
[ March 12, 2002: Message edited by: Jamie Robertson ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Access - run Compact and Repair from Java
 
Similar Threads
how can i compact msaccess db from java?
size of table is increasing
Access - run Compact and Repair from Java
Compact and Repair Access Database
Compact Access Database