0
0 Comments

Problem: Failing to start a DataMacro on a SharePoint 2013 table, when called from an Access web database.

Environment: Access 2010, SharePoint 2013 using SSL

Details:  We have a web database created using Access 2010, and based on around 5 relational (using lookups) SharePoint lists to store data. One of the forms in the database has a button with macro code using the RunDataMacro action to call a data macro on one of the lists and pass in 4 pieces of data as parameters. One parameter identifies the record to be updated, and the other 3 are used to update fields in the record. Originally this was set up on a SharePoint 2010 environment and worked without problem.

 

Since moving to SharePoint 2013 using SSL, the macro does not run and an error is encountered. The Application Log Table records a description of ‘Failed to start’ against the execution of the macro, with an error number of ‘-4002’. A new macro was created which contained no actions, but this also failed to start. So it appears to be the action of trying to call or run the macro rather than what the macro is doing that is the issue.

 

Could this be something in the settings of SharePoint 2013 and/or the SSL?

 

(Visited 34 times, 1 visits today)
Add a Comment