aspose 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 Soft Skills this week in the Jobs Discussion 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: 12835
    
    5
You would do a lot better in a JDBC related forum!
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
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 ]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Access - run Compact and Repair from Java