Anyone knows how to compact a MSAccess database through code??
Thx.
Xmas
Printable View
Anyone knows how to compact a MSAccess database through code??
Thx.
Xmas
I don't know if you still need this or not but I believe if you open the database as an object (referencing the access activex component) then you can compact it from the database object itself.
http://support.microsoft.com/default...b;en-us;306287
It uses the JRO...
Be Careful to change the example so that the destination file is different from the orginal file (Compact from, Comact to)
Good Luck:afrog: :afrog: :thumb: