C
cabrenner
I have an application created in Access 2002. Initially it would not
run when opened in Access 2007 due to the SetWarnings macro used
during startup. This has been solved by enabling macros and assigning
the folder in which the databases (FE and BE) are stored as a "Trusted
Location". However, the application still fails with the following
error:
Run-time error '2501':
The RunMacro action was canceled.
Upon clicking "Debug", the code stops on the following statement:
DoCmd.RunMacro "CheckTables"
The CheckTables macro calls a function that checks the table linking
of the front end db to the backend db, and updates it if necessary.
If I eliminate the DoCmd.RunMacro statement, and call the function
directly from VBA, the code runs fine and the app opens OK. I have
been trying to find a reason for the failure of the DoCmd.RunMacro
statement, but have come up with nothing.
Any ideas would be greatly appreciated.
Thanks.
Cheryl
run when opened in Access 2007 due to the SetWarnings macro used
during startup. This has been solved by enabling macros and assigning
the folder in which the databases (FE and BE) are stored as a "Trusted
Location". However, the application still fails with the following
error:
Run-time error '2501':
The RunMacro action was canceled.
Upon clicking "Debug", the code stops on the following statement:
DoCmd.RunMacro "CheckTables"
The CheckTables macro calls a function that checks the table linking
of the front end db to the backend db, and updates it if necessary.
If I eliminate the DoCmd.RunMacro statement, and call the function
directly from VBA, the code runs fine and the app opens OK. I have
been trying to find a reason for the failure of the DoCmd.RunMacro
statement, but have come up with nothing.
Any ideas would be greatly appreciated.
Thanks.
Cheryl