Hello,
I'm having a bit of trouble with one of my named macros after publishing the database to SharePoint.
I have 3 tables: "Users", "Tasks", and "Metrics". The macro is associated with the "Metrics" table and is designed so that when I delete a user or a task from their respective tables, the macro goes through the Metrics tables and deletes all records related to that user or task.
The macro is invoked by a button on one of the forms. The macro was working fine when the database was being run locally, but after publishing to SharePoint I get a "Failed to start macro" error. The next window displays "Error Number: 2950".
The USysApplicationLog displays 2 errors:
I've had no luck figuring this one out myself, and I've tried researching the issue online to no avail. Any help is much appreciated!
Thank you.
I'm having a bit of trouble with one of my named macros after publishing the database to SharePoint.
I have 3 tables: "Users", "Tasks", and "Metrics". The macro is associated with the "Metrics" table and is designed so that when I delete a user or a task from their respective tables, the macro goes through the Metrics tables and deletes all records related to that user or task.
The macro is invoked by a button on one of the forms. The macro was working fine when the database was being run locally, but after publishing to SharePoint I get a "Failed to start macro" error. The next window displays "Error Number: 2950".
The USysApplicationLog displays 2 errors:
- -4002: Failed to start macro
- -3204: Failed to iterate over table 'Metrics'
I've had no luck figuring this one out myself, and I've tried researching the issue online to no avail. Any help is much appreciated!
Thank you.