When I do it on SP 2007, I always get 'Publish to SP site' option in MS Access 2007. But on 2010, I get 'Save to SP site' option

Steps I am following to create Access view on SP 2010 Discussion Board or List:

1) Click on create Access view.
2) It opens a new instance of MS Access 2010 on my machine and asks me to save it.
3) After I save it, I select what feature I want to use (Forms, Reports, etc). I create a report and save it.
4) Then, I 'save it to SharePoint site'(for e.g. Shared Documents library).
5) After following the above steps, my report name should appear in the drop down selection of views on the Discussion Board or List. But it doesn't?

I am able to do this on SP 2007 and it works like a charm. Any idea what am I doing wrong here?

Note: When I do it on SP 2007, I always get 'Publish to SP site' option in MS Access 2007. But on 2010, I get 'Save to SP site' option.

Hi Nikhil,

I understand that you want to create Access View for a list. In SharePoint 2010, when create an view in Access 2010, you can only choose to ¡®Save to SharePoint Site¡¯ to save the .accdb file to a SharePoint document library. User then can access the reports or forms in the document library instead. The .accdb file will be opened in Access application.

If you publish the Access database to Access Service, it will create a new site for the Access database, you can view the forms and reports in browser.

For more information about publish a access database to SharePoint, you can refer to this site:

SharePoint 2010 and Access 2010: htt-p://www.youtube.-com/watch?v=Dq-tDuPfgZc