Managing external connections

In the previous section, you learned how to open a read-only external connection to your web app to allow Access to create a reporting desktop database linked to your web app tables. Access provides other options for managing external connections to your web app, including read-write connections, which allow you to connect your web apps tables with other programs such as Microsoft Access, Microsoft Excel, or any other SQL database that supports the Open Database Connectivity (ODBC) software standard.

To view and modify external connections for your web app, you’ll need to open the app within Access first. If you still have the Back Office Software System sample web app (BOSS.app) open from the previous section, you ...

Get Microsoft Access 2013 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.