Hello folks,
I have an AccessDB with a size of abound 30 MG. There are tons of macros in it. I am responsible for running some production jobs at the beginning of a month. A few associates did the similar thing a few days ago. As I took over, I found none of the butotns, back up by some macros, were not working. As I use Alt/F11 to check them, there were none.
I do have more than one backup copies of the DB. But they are from the previous months. If I take one of them, the monthly update of the latest month won't exist. I need probably re-run all the macros to keep them update.
I thought about import the macros from the previous backup copies into my current corrupted DB file. This is what I did:
first open the problem DB, the one has no macros;
then
Goto External Data then New Data Source then From Database: Access then specified the pathh of my decent DB file, the file has macros; then click OK then start copying; after done, but I don't see macros in the Tool dropdown, except for one: Autoexecute macro.
No idea what's going on.
Please advise.
Thanks.
I have an AccessDB with a size of abound 30 MG. There are tons of macros in it. I am responsible for running some production jobs at the beginning of a month. A few associates did the similar thing a few days ago. As I took over, I found none of the butotns, back up by some macros, were not working. As I use Alt/F11 to check them, there were none.
I do have more than one backup copies of the DB. But they are from the previous months. If I take one of them, the monthly update of the latest month won't exist. I need probably re-run all the macros to keep them update.
I thought about import the macros from the previous backup copies into my current corrupted DB file. This is what I did:
first open the problem DB, the one has no macros;
then
Goto External Data then New Data Source then From Database: Access then specified the pathh of my decent DB file, the file has macros; then click OK then start copying; after done, but I don't see macros in the Tool dropdown, except for one: Autoexecute macro.
No idea what's going on.
Please advise.
Thanks.