Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Access 2010 has some wonderful templates. So, I was planning to use one of those on my SP2010 site. But before starting I have some questions:

  1. When an Access 2010 templates is published in Sharepoint 2010 site, where is database stored & can it be accessed by our coders? Can I have a SQL database as back-end for data of these published templates
  2. Are there any other ways of syncing database with an external source. If yes, what are the requirements of the external source?

Any tutorial or links would be of great help!

Thanks!

share|improve this question

1 Answer 1

up vote 1 down vote accepted

If you have SQL as a backend, you can use the data from there as External Content Types out of the box and the data will remain in that location and be displayed as lists within your site. These lists can be used just like any other list in SharePoint, you can create, read, update or delete the items in the list if you create them with the appropriate operations. There are also several cool things you can do with Access Services in 2010. There are several posts about it and what you can do with it here: http://blogs.office.com/b/microsoft-access/archive/tags/2010+intro+series/default.aspx.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.