topic Integrating Microsoft Access Database with ArcGIS Online in Electric Questions https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/49577#M46 <HTML><HEAD></HEAD><BODY><P>. I currently have FuturaGIS for Electric Utilities. It runs on ESRI ArcGIS Desktop 10.4 . I want to add&nbsp;a web based platform as a part of my GIS capabilities. I want to give others in my organization the ability to view (NOT EDIT) data, create maps, and possibly run analysis. Is it possible to connect a Microsoft Access Database to ArcGIS Online and have the data update regularly without having to manually do so? If not, then how do i create a regularly updated web version of our database for others to access? Would I need ArcGIS Enterprise to accomplish this?</P></BODY></HTML> Tue, 21 Jan 2020 18:11:26 GMT DanielMoye 2020-01-21T18:11:26Z Integrating Microsoft Access Database with ArcGIS Online https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/49577#M46 <HTML><HEAD></HEAD><BODY><P>. I currently have FuturaGIS for Electric Utilities. It runs on ESRI ArcGIS Desktop 10.4 . I want to add&nbsp;a web based platform as a part of my GIS capabilities. I want to give others in my organization the ability to view (NOT EDIT) data, create maps, and possibly run analysis. Is it possible to connect a Microsoft Access Database to ArcGIS Online and have the data update regularly without having to manually do so? If not, then how do i create a regularly updated web version of our database for others to access? Would I need ArcGIS Enterprise to accomplish this?</P></BODY></HTML> Tue, 21 Jan 2020 18:11:26 GMT https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/49577#M46 DanielMoye 2020-01-21T18:11:26Z Re: Integrating Microsoft Access Database with ArcGIS Online https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/49578#M47 <HTML><HEAD></HEAD><BODY><P>You cannot integrate and publish a Microsoft Database&nbsp; (.mdb) to ArcGIS Online.</P><P>You will need to move your database tables to a file geodatabase or and SDE</P><P>Granted you then lose the significant advantages or working with Access</P></BODY></HTML> Mon, 27 Jan 2020 16:49:38 GMT https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/49578#M47 RobertBorchert 2020-01-27T16:49:38Z Re: Integrating Microsoft Access Database with ArcGIS Online https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/49579#M48 <HTML><HEAD></HEAD><BODY><P>Thank you Robert, I forgot to mention that the database is currently on an SDE. Since this is the case, How would I integrate the database with ArcGIS Online?&nbsp;</P></BODY></HTML> Fri, 14 Feb 2020 18:08:09 GMT https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/49579#M48 DanielMoye 2020-02-14T18:08:09Z Re: Integrating Microsoft Access Database with ArcGIS Online https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/49580#M49 <HTML><HEAD></HEAD><BODY><P>Technically speaking if it is in SDE then it is no longer a MS Access Database.</P><P>Can you add tables from your SDE into ArcMap or ArcGIS Pro?</P></BODY></HTML> Tue, 18 Feb 2020 17:03:32 GMT https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/49580#M49 RobertBorchert 2020-02-18T17:03:32Z Re: Integrating Microsoft Access Database with ArcGIS Online https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/49581#M50 <HTML><HEAD></HEAD><BODY><P>Yes, I can add them into ArcMap. We currently don’t have ArcGIS Pro so I’m not sure about adding them there. There are a few other databases that are linked to the GIS and they are updated/used by other departments using separate software programs. There are multiple tables that are connected to my “Editing” map document that I work with daily. These tables contain customer data and billing information.&nbsp;</P></BODY></HTML> Wed, 19 Feb 2020 03:55:21 GMT https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/49581#M50 DanielMoye 2020-02-19T03:55:21Z Re: Integrating Microsoft Access Database with ArcGIS Online https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/1254858#M783 <P>Yes You Can</P><P>VBA</P><P>Use the ServerXMLHTTP60 object to create a request of the AGOL server.<BR />Setup an account in ArcGIS Developers and create OAuth 2.0 Application to manage the authentification.</P><P>The trick with the update (POST), you update the ENTIRE record, INCLUDING COORDINATES, and not just the field.&nbsp; So I GET the record from the FeatureLayer I want to update, do some string magic, then POST the updated record back to the FeatureLayer.</P> Fri, 03 Feb 2023 15:31:26 GMT https://community.esri.com/t5/electric-questions/integrating-microsoft-access-database-with-arcgis/m-p/1254858#M783 Hornblower5953 2023-02-03T15:31:26Z