Pselus
07-30-2003, 02:15 PM
I have a project that opens Access (on the clients machine) to display a report, I'm using vbscript to do this. What I need to do is figure out the state access is in before opening. Basically when someone closes Access after displaying a report Access compacts itself and takes a couple seconds to close. If the user clicks the button to open access before it's done compacting I will have problems. So I need to check the state and maybe loop until Access is fully done compacting.