We have a small SharePoint 2010 farm, having one Front End server and one Application server. We’ve just created a new Site, based on the Assets Web Database template (one of the default Web Database templates). The site was created successful. However, when accessing this site we get the Failed to start macro VerifyUsers, without further details, as you can see in the following screenshot.
After some Googling and several tests on my Lab, I figured out that Access Services and the Microsoft SharePoint Foundation Web Application go hand in hand (there is some relationship between them). Let me explain: my small SharePoint farm had one dedicated Application Server, running several SharePoint shared services, as Access Services, Excel Services, and so on. However, this dedicated Application Server was not running the Microsoft SharePoint Foundation Web Application service, and I was getting the Failed to start macro VerifyUsers error message.
After that, I started the Microsoft SharePoint Foundation Web Application on the Application server. Then, I tried to access to my Web Database Site, and surprisingly, I could access with success to the Assets Web Database site. Access Services is running (it works like a charm ;-).
That's all for today. I hope you enjoy the reading ! Cheers