Compact from Code and 'Not Responding' alert

[Middlemarch]

Can I compact and repair from an instruction in code, rather than clicking the ribbon ?

While looping through a large array access will report "Not Responding" at top of screen. But it is actually doing what's it told
and eventually completes and all is ok. Can the 'Not Responding" alert be prevented or hidden ?

[Micron]

Don't think it can be hidden unless you go the route of hiding the application window, and even then, not sure. I wouldn't worry about it if you're the only user because all it means is that "I'm busy doing what you asked me to do, so stop poking around or asking for something else until I'm done." It's not a crash thing, or an error of any kind.

OK, one exception about something that may provide some relief is to make sure your query or other operation is as efficient as it can be, or parse it into tasks. I doubt there is an API for working with an array, but if there is, that might help.

[isladogs]

Can I compact and repair from an instruction in code, rather than clicking the ribbon ?

No. The functionality to do this on an open database was removed with Access 2010

[Middlemarch]

Thanks for the replies

[Micron]

an I compact and repair from an instruction in code, rather than clicking the ribbon

I didn't necessarily think OP meant while open. You're saying you can no longer compact and repair via vba code upon closing? I thought that was possible around 2013.

[isladogs]

OK for completeness, there are four possible methods of compacting a file
1. From the ribbon whilst open
2. Using the Compact on Close setting in Access Options (not recommended)
3. Opening the file using the /compact command line switch
4. Using code on another closed database

At one stage, you could also compact an open database using SendKeys but I believe that is no longer possible either.