Forum Discussion
MS Access (Office 365) Command buttons do not work on a cloned DB
I have a bookkeeping application. Every year I copy and paste the DB with a new name and remove the data from the tables relating to the bookkeeping entries of the previous year. This time af...
Thank you for your reply and I very much appreciate your suggestion. A follow up question, which is based on a perhaps unwarranted desire for year to year data segregation. What do you think about the idea simply cloning the tables?
Regarding my primary DB (not bookkeeping), which also has command buttons as well make s use of the on-click within controls, I did an experiment. I copied and pasted the DB. I had the same issue. Command buttons and on-click of controls within forms do not work.
Regarding my primary DB (not bookkeeping), which also has command buttons as well make s use of the on-click within controls, I did an experiment. I copied and pasted the DB. I had the same issue. Command buttons and on-click of controls within forms do not work.
I am not an expert in accounting, but I don't think it's standard practice to segregate data year-to-year, PHYSICALLY. My bank certainly doesn't do that, nor do standard off-the-shelf accounting packages. So, while I am not going to be adamant, it does seem to be out-of-mainstream practice. Cloning tables is roughly the same thing, IMO.
To focus, though, on this problem. I asked if the accdbs are both in a Trusted Location. It's also important to allow macros to run. Although the dialog refers only to macros, this does include VBA,
Although that's the most likely source of this problem (one or the other property, or both), it could be something else. Start there. See if that corrects the problem.
- Thank you very much! The issue has been resolved by "enabling all macros". I do appreciate also the instructive comments regarding the bookkeeping application, which I plan to implement.