--- description: In this article we look at linking MS Access with Microsoft’s cutting edge Dynamics 365 ERP platform to allow data synchronization. title: How to Link MS Access 2016 with Data from Dynamics 365 image: https://www.datanumen.com/blogs/wp-content/uploads/2017/10/linking-ms-access-2016-with-data-from-dynamics-365.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Access Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/access-solutions/) > How to Link MS Access 2016 with Data from Dynamics 365 # How to Link MS Access 2016 with Data from Dynamics 365 [Access Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/access-solutions/) September 29, 2025 Share Now: - - - - - - - - *In this article we look at linking MS Access with Microsoft’s cutting edge Dynamics 365 ERP platform to allow data synchronization.* Microsoft allows users to link their MS Access data with Microsoft Dynamics 365, a powerful business management tool based on an intelligent cloud application that integrates ERP (Enterprise Resource Planning) modules in a single software package. Given the fact that Dynamics 365 spans across several modules like finance, sales, and CRM (Customer Relationship Management) modules; linking Access data with this cutting edge software can prove beneficial in several cross functional scenarios.![Linking MS Access 2016 with Data From Dynamics 365](https://www.datanumen.com/blogs/wp-content/uploads/2017/10/linking-ms-access-2016-with-data-from-dynamics-365.jpg "Linking MS Access 2016 with Data From Dynamics 365") When you link data between these two applications, Access develops a two-way link or connection that automatically synchronizes changes in the data of Dynamics 365 and MS Access. ## Benefits of Linking MS Access 2016 with Data from Dynamics 365 - ![Microsoft Dynamics 365](https://www.datanumen.com/blogs/wp-content/uploads/2017/10/microsoft-dynamics-365-300x150.jpg "Microsoft Dynamics 365")Linking Dynamic and Access can help increase data security and work efficiency sharing data within the designated team. - It integrates and increases data security but restricting changes on a single software only. - By connecting Access database with business modules users will be able to transfer and optimize the data across its multiple ERP modules. - Dynamics 365 centralizes users’ data in a single interface by integrating it with other applications like Access, through its cloud services and external data sources. ## Important Things to Note for Smooth Operations - Identify and collect necessary connection information, like URL of Dynamics 365 site and a security access account. - In case your company doesn’t have a 365 Account, users can sign up for one. - Secure your data by creating a backup of your Access database and its connection information at a trusted location using an Access database password. - Identify and select all the tables that you wish to link. Users can link multiple tables in one command or operation. - Before you start linking your Access database, it is advisable to keep a [Access repair](https://www.datanumen.com/access-repair/) tool ## Steps to Link MS Access 2016 with Data from Dynamics 365 ### STAGE 1 - **Step 1:** Select External Data, and then click on New Source Data. - **Step 2:** Now select Form Online Services and then select Dynamics O365 (Online). - **Step 3:** Now copy the URL of your Dynamics 365 account in the dialog box, ‘Enter the URL of the Dynamics 365 Site’. - **Step 4:** To link these software’s data sources users will need to create a linked table. - **Step 5:** Select Ok. ### STAGE TWO - **Step 1:** Now the users will be requested to select Tables under ‘Link Tables’ dialog box. Users can select one or more table at a time. - **Step 2:** Once you have selected all the tables, click OK. Note that when this linking operation completes, the table will appear in Navigation Pane, using the same name on Dynamic 365 table. Also, in the link operation, if columns are set at read-only in Dynamics 365 table, it will also appear as read-only in Access. ## Update Linked Table Design Users can’t add, remove, delete or modify any data type or columns in a linked table. In case a user wants to make design changes, he/she can implement them on Dynamic 365, which will automatically reflect on Access whenever the table will be opened or used. ## Author Introduction: Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [fix mdf](https://www.datanumen.com/sql-recovery/) and excel recovery software products. For more information visit [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/add-object-library-reference-vba/) [Next post →](https://www.datanumen.com/blogs/quickly-export-image-attachments-outlook-email-excel-worksheet/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/link-ms-access-2016-data-dynamics-365\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/link-ms-access-2016-data-dynamics-365\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Link MS Access 2016 with Data from Dynamics 365","datePublished":"2017-10-10T05:53:36+00:00","dateModified":"2025-09-29T04:09:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/link-ms-access-2016-data-dynamics-365\/"},"wordCount":551,"commentCount":0,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/link-ms-access-2016-data-dynamics-365\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/linking-ms-access-2016-with-data-from-dynamics-365.jpg","articleSection":["Access Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/link-ms-access-2016-data-dynamics-365\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/link-ms-access-2016-data-dynamics-365\/","url":"https:\/\/www.datanumen.com\/blogs\/link-ms-access-2016-data-dynamics-365\/","name":"How to Link MS Access 2016 with Data from Dynamics 365","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/link-ms-access-2016-data-dynamics-365\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/link-ms-access-2016-data-dynamics-365\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/linking-ms-access-2016-with-data-from-dynamics-365.jpg","datePublished":"2017-10-10T05:53:36+00:00","dateModified":"2025-09-29T04:09:26+00:00","description":"In this article we look at linking MS Access with Microsoft’s cutting edge Dynamics 365 ERP platform to allow data synchronization.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/link-ms-access-2016-data-dynamics-365\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/link-ms-access-2016-data-dynamics-365\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/linking-ms-access-2016-with-data-from-dynamics-365.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/linking-ms-access-2016-with-data-from-dynamics-365.jpg","width":733,"height":252,"caption":"Linking MS Access 2016 with Data From Dynamics 365"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```