I haven't found anything like this for Access. When you think about it, this function is one that does not fall into the scope of ODBC. The function of ODBC is to simply provide generic access to the data in a database through SQL. Tools used to support that database fall outside of that scope. In the past (in order to avoid including DAO in my project) I have created an Access object and used that to compress and repair a database.<br><br>rekclaw
Visual Studio comes with an Object that does that, aleast one of the two. It's called the Microsoft Jet and Replication Object. I just implemented the compact function into my program. Works great! One thing though, It's doesn't work through ODBC. You have to have the direct path to the MDB file. Oh, and it only does a compact. but I have a theory that the Access compact does both.<br><br> <p>Clayton T. Paige<br><a href=mailto:cpaige@home.com>cpaige@home.com</a><br><a href=
Snail</a><br>Clayton T. Paige<br>
Programmer Extraordinaire <br>
========================================================<br>
"Who General Failure? and Why is he reading my disk drive?
You could try using the database object and the CompactDatabase function<br><br><br>Nikhil<br><A HREF="mailto:nikhilmehrotra@mailmetoday.com">nikhilmehrotra@mailmetoday.com</A>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.