Sync Access Web App to another Access Web App or SQL database

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

Answer 1

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

Answer 2

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

Answer 3

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.

Answer 4

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

Answer 5

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

Answer 6

I agree with the architecture but until Access Web changes the database max size we had to create multiple apps.

---

John Fletcher