I have an Access application that is split in a front end/back end configuration. Before a particularly large update procedure is called, I would like to save a copy of one of the back end tables in case the user input the incorrect parameters and the table needs to be restored to the previous version.
My question is: Is it possible to insert the table into the back end file from the front end?
*Bonus question: How does Access handle index fragmentation? Does Access rebuild the indices during a compact and repair?