Search results

I am placing a breakpoint within a function that runs after an update. The function runs, but the break does not happen. Is there some setting that can be adjusted that allows this to happen?

The update is once early in the morning but it is more complex than being able to just create a temporary DB. The database that is being updated is tied closely with IT and I cannot change anything within it. Basically the update is set in stone. I need a way to be able to compact and repair...

What version of Access do you use? I am looking for this exact thing, but have been unable to find the solution on 2007. I have written code within the database that automatically closes access if you have been inactive for an hour, so I do not need to check for a .idb.