Screen turning white while compacting

[John Zelmer]

Hi, for our company's Access 2013 application we use a Start.accde which, daily at first startup, compacts and then backups the backend, before opening the frontend. Before the Start.accde starts compacting the backend, it shows a form with an estimation of the compacting duration (now about 3 minutes) calculated on the basis of earlier compacting durations. However, after about 10 seconds after the start of the actual compacting the form turns white and the user can't see anymore what's going on. It seems like Access hangs while in fact in the background it is working properly. Is there some way to prevent this form turning white from happening? Or any other ideas for a better User Interface so that the user knows what's going on? Thanks in advance,
John

 

[missinglinq]

No idea on your current problem, sorry...but you really need to change the order of things, here! Compacting a database is a not uncommon cause of database corruption, so you really need to do the backup then do the compacting...unless you're really into corruption recovery!

Of course, most experienced developers will tell you that once rolled out...a well designed db seldom needs to be compacted on a daily basis.

Linq ;0)>

 

[Ranman256]

This can happen. While Access is running a process , you can't perform any other action and sometimes it doesn't have time to redraw the screen.
Let it be.

 

[John Zelmer]

Thanks. My understanding is that it is good to prevent corruption by compacting and in that way fixing errors that haven't occured as corruption yet. And I thought compacting fixes corruption in stead of causing it. I understand that the most experienced developers say that a well designed db doesn't need daily compacting. But in my case I have no control over the network and I can't prevent network hickups to and because of it corrupted files.

 

[John Zelmer]

Thanks Ranman, though I really don't like this behavior in Access. I will check out if I can set an extra status message but I think it will be overridden by the compact action.