Experts:
I'm requiring some assistance with preventing the "AutoExec" dialog box to show up **after a the file name was changed**.
Please find attached an example database. Follow the steps below:
1st Time Opening the Database:
1. Unzip database.
2. Open up database "Test".
3. You will get a prompt "Macro Single Step". Close on "Stop All Macros".
4. Close form "User View".
5. Click "Enable Content".
6. Form "User View" pops up.
7. Close database.
2nd Time Opening the Database:
1. Open up database "Test".
2. Form "User View" pops up.
As illustrated above, the 2nd time around, I do NOT get the "Macro Single Step" and "Enable Content" dialogue boxes. However, if I were to rename the database from, e.g., "Test" to "Test_2", I will receive the "Macro Single Step" and "Enable Content" dialogue all over again once I re-open the DB.
Now, I'm actually perfectly having my users acknowledge/click on the "Enable Content" dialogue box. However, I do NOT want the users to always having to click on the "Macro Single Step" each time the file was copied/pasted/renamed.
My question: How can I prevent the Macro-related dialogue box pop up while still tracking the login information in table "tbl_Db_UserTracking"?