topic Re: Connecting an Access Front end to an ArcGIS SDE/SQL table: in Data Management Questions https://community.esri.com/t5/data-management-questions/connecting-an-access-front-end-to-an-arcgis-sde/m-p/611700#M34487 <HTML><HEAD></HEAD><BODY><SPAN>Hi Mark,</SPAN><BR /><BR /><SPAN>Are you using Microsoft Access 2010?&nbsp; If so, take a look at the information under 'Link to SQL Server Data' within the following </SPAN><A href="http://office.microsoft.com/en-us/access-help/import-or-link-access-to-sql-server-data-HA010341762.aspx">link</A><SPAN>.</SPAN><BR /><BR /><SPAN>A few things you should consider when dealing with a SDE table/feature class.&nbsp; If the data is registered as versioned, the edits will be stored in the delta (A &amp; D) tables.&nbsp; In this case, it would be best to create a </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//006z0000000q000000">versioned view</A><SPAN> and access this view to view the edits.&nbsp; </SPAN><BR /><BR /><SPAN>Or, you can perform a </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//003n000000s5000000">compress</A><SPAN> of the geodatabase.&nbsp; This will move the edits from the delta tables to the base table.</SPAN></BODY></HTML> Mon, 31 Dec 2012 13:41:48 GMT JakeSkinner 2012-12-31T13:41:48Z Connecting an Access Front end to an ArcGIS SDE/SQL table: https://community.esri.com/t5/data-management-questions/connecting-an-access-front-end-to-an-arcgis-sde/m-p/611699#M34486 <HTML><HEAD></HEAD><BODY><SPAN>I am attempting to connect an Access front end to a existing SQL Server table housed in a SDE Geodatabase.&nbsp; Can someone please point me to a source on how to accomplish this task?&nbsp; Thank you!!!</SPAN></BODY></HTML> Mon, 31 Dec 2012 12:04:40 GMT https://community.esri.com/t5/data-management-questions/connecting-an-access-front-end-to-an-arcgis-sde/m-p/611699#M34486 MarkEnglish 2012-12-31T12:04:40Z Re: Connecting an Access Front end to an ArcGIS SDE/SQL table: https://community.esri.com/t5/data-management-questions/connecting-an-access-front-end-to-an-arcgis-sde/m-p/611700#M34487 <HTML><HEAD></HEAD><BODY><SPAN>Hi Mark,</SPAN><BR /><BR /><SPAN>Are you using Microsoft Access 2010?&nbsp; If so, take a look at the information under 'Link to SQL Server Data' within the following </SPAN><A href="http://office.microsoft.com/en-us/access-help/import-or-link-access-to-sql-server-data-HA010341762.aspx">link</A><SPAN>.</SPAN><BR /><BR /><SPAN>A few things you should consider when dealing with a SDE table/feature class.&nbsp; If the data is registered as versioned, the edits will be stored in the delta (A &amp; D) tables.&nbsp; In this case, it would be best to create a </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//006z0000000q000000">versioned view</A><SPAN> and access this view to view the edits.&nbsp; </SPAN><BR /><BR /><SPAN>Or, you can perform a </SPAN><A href="http://resources.arcgis.com/en/help/main/10.1/index.html#//003n000000s5000000">compress</A><SPAN> of the geodatabase.&nbsp; This will move the edits from the delta tables to the base table.</SPAN></BODY></HTML> Mon, 31 Dec 2012 13:41:48 GMT https://community.esri.com/t5/data-management-questions/connecting-an-access-front-end-to-an-arcgis-sde/m-p/611700#M34487 JakeSkinner 2012-12-31T13:41:48Z