How to connect Access 2010 to SharePoint and SQL Server 2008
Posted on 2013-06-25
I was wondering..... Can I use an Access 2010 template which is linked to a SQL server Database to somehow link it to SharePoint Foundation 2010 and then SharePoint back to the SQL server where all the data from both the Access 2010 and SharePoint Foundation will be stored? Meaning that the Sharepoint will have some kind of a form just like the Access template and then it will be able to see the SQL server and sync all data back and forth...... Let's say I would like to see or enter a new record using any browser..... I would be able to see the same forms and data that the Access template has and when I enter I new student information it would be stored in the SQL server and show this new student on the Access template on my computer and Sharepoint too...... SQL server, Access 2010, and SharePoint Foundation 2010 would sync back and forth.... Is this possible? Is there a way to do this?
Thanks a lot!