Hello,

I was hoping someone could help me out.

I make a simple compression utility that will compress a database using this command:

JRO.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & srcDB & ";Jet OLEDBatabase Password=" & "Zambonie2000", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & destDB & ";Jet OLEDBatabase Password=" & "Zambonie2000" & ";Jet OLEDB:Engine Type=4"
Kill srcDB

I want to have a progress bar track this somehow. The problem is I have no idea how long the compression is going to take so I don't know what the MAX value would be. And everytime I write some type of code to get the increment the progress bar it doesn't run until the compression is done.

So hopefully all that made sense. If you have a suggestion or if you can steer me in the correct direction that would be fantastic.

Thank you,