none
Sync Access Web App to another Access Web App or SQL database RRS feed

  • Question

  • Hello,

    We have a top level SQL database and would like to pull summary data from several departmental Access Web Apps. Is there a way to do this? Secondly, is there a way to sync data between two Access Web Apps?

    Thanks

     

    John Fletcher

    Wednesday, July 27, 2016 12:12 AM

Answers

All replies

  • There is nothing built into Web Apps to do that, but you can use normal SQL Server tools such as SSIS to do that.

    -Tom. Microsoft Access MVP

    Wednesday, July 27, 2016 2:09 AM
  • You will have to create your own mechanism for this.

    Daniel Pineault, 2010-2012 Microsoft MVP
    http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Wednesday, July 27, 2016 2:14 AM
  • Hi John,

    >> We have a top level SQL database and would like to pull summary data from several departmental Access Web Apps. Is there a way to do this?

    For pulling data from Access web apps, when you use Access 2013 to create a web app on SharePoint, Access Services will create a SQL Server or SQL Azure database that houses all of your Access objects. You could refer the link below for more information about connecting to the SQL Server or SQL Azure database of Access web app back end.

    # Access 2013 and SQL Server

    https://blogs.office.com/2012/08/08/access-2013-and-sql-server/

    >> is there a way to sync data between two Access Web Apps?

    As the reply from Tom and Daniel, there is not built-in function to sync data. I suggest you try suggestion from Tom by using SSIS.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Wednesday, July 27, 2016 2:31 AM
  • Thanks Tom - will I need to do this for each departmental Access Web App? And would the same process work to update one Access Web App from another Access Web App?

    John Fletcher

    Wednesday, July 27, 2016 3:07 AM
  • SSIS can connect to many data sources.

    If this becomes a major project, you may need to re-think the current architecture A bunch of standalone web apps, each controlled by one department, while the company as a whole is in need of integrated data, sounds like bad architecture to me.


    -Tom. Microsoft Access MVP

    Wednesday, July 27, 2016 1:30 PM
  • I agree with the architecture but until Access Web changes the database max size we had to create multiple apps.

    John Fletcher

    Wednesday, July 27, 2016 1:35 PM