# Personal geodatabase

<table data-header-hidden><thead><tr><th width="193.5"></th><th></th></tr></thead><tbody><tr><td>Read</td><td>Yes</td></tr><tr><td>Write</td><td>Yes</td></tr></tbody></table>

JMap Server can read ESRI Personal geodatabases to extract spatial and attribute data to be used as a spatial data source. This format uses Microsoft Access files to store the data. The connection to the Access database must already be configured using the MS Access driver. See [Creating Databases](https://docs.k2geospatial.com/en2/administrator/jmap-server-administrator-manual/databases/creating-databases) for more information on this topic.

<table data-header-hidden><thead><tr><th width="191.5"></th><th></th></tr></thead><tbody><tr><td><strong>Parameters</strong></td><td> </td></tr><tr><td>Database</td><td>Select the database to read the data from. This database must connect to an MS Access file. It must already be configured in JMap Admin.</td></tr><tr><td>SQL query</td><td>Enter the SQL query used to extract geometries and attributes from the database.</td></tr><tr><td>Geometry table</td><td>Select the physical table that effectively contains the geometries. Pressing <strong>Load</strong> will retrieve the list of fields returned by the query. This is necessary for the rest of the configuration.</td></tr><tr><td>Id field</td><td>Select a field that contains unique identifiers. Only integer fields are listed. The field is usually called OBJECT_ID.</td></tr></tbody></table>