I have a published Access 2010 Web Database on my SharePoint 2010 site. The forms and tables all work as expected, but I would like to query this database from SQL Server. Is this possible?
Essentially I have a ticketing system set up in SharePoint via this Access Web Database, and another tool that stores its data in SQL Server. I want to use data from the ticketing system in queries for that tool.
I've seen answers to questions wanting to go the other way (link SQL Server tables in an Access Web Database), and understand that's not really possible, but I'd like to access the data in the Web Database from SQL Server.