Hai,

In my program i populate tables in an Ms access Database. The database is huge sometimes (aroung 600 MB). When this Database is Compacted through Access it becomes around 80 MB.
How do i perform the same compact operation through Java code.
Note: Without using zip...

Thanks,
Safi

Are you referring to 'compact and repair database' option in Access?
If so I wouldnt have thought you would be able vsll it from Java as it is part of the access application as opposed to part of the database itself (the mdb file).

There may be a java api that performs a similar function, but I am not aware of one but Im still a beginer so its worth looking.

Would be interested if there were tools available to do this