This morning my Work Order database was giving a "Invalid Argument (3001)" error message on one of my queries. After some troubleshooting, I figured out it something was corrupt. So I ran Compact and Repair and this fixed my problem. The people who use this database are not very familiar with Access so I thought I would write a macro and assign it to a button where they can periodically do a compact and repair. Well sure enough there are built in macro Run Commands for "CompactDatabase" and "RepairDatabase". So I made a macro to close the open one open form, then run RepairDatabase, then run CompactDatabase. However when I run the macro, I get the error message "You can't compact the open database while running a macro". Well why are these run commands built into Access macros if you can't do it?
Am I doing somethign wrong or is there an easier way have novice Access users the ability to run compact and repair?
Thanks,
Jim
Am I doing somethign wrong or is there an easier way have novice Access users the ability to run compact and repair?
Thanks,
Jim