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 OLEDB:Database Password=" & "Zambonie2000", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & destDB & ";Jet OLEDB:Database 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,
