I have an existing Microsoft SQL Server database which has been configured as an Enterprise geodatabase. I want to access it in MS Access in order to extract data to populate a form. What is the proper way to connect it? I have an ArcGIS Enterprise connection file named: "G:\Database Connections\eGIS_Cadastral on EGISDBP1 as viewer.sde"

So far I went to new data source > from other source > odbc database and chose Link data source. It now wants a file data source. What is that?

Here is an image on where I am stuck:

enter image description here

This is an image of the connection properties in ArcMap:

enter image description here

  • To what 'DNS' are you referring? Domain Name Service isn't file-oriented, although it uses a hosts file as a resource – Vince Apr 10 '19 at 15:24
  • I am not sure where you insert the host file. I am stuck at the part of selecting the data source. – brandon p Apr 10 '19 at 15:59
  • I tried to click new and now wants a ODBC File Data Source. Is that the host file? – brandon p Apr 10 '19 at 15:59
  • Please Edit this question to clarify the task you are attemping to complete – Vince Apr 10 '19 at 16:14
  • Hello Vince. I have edited the question. – brandon p Apr 10 '19 at 16:35

You have to use the ODBC in Windows to add the proper driver and set-up the DNS.

| improve this answer | |
  • This is similar to a link-only answer, except it doesn't have a link. Please provide details to expand upon the steps necessary. – Vince Apr 10 '19 at 23:22

Not the answer you're looking for? Browse other questions tagged or ask your own question.