/
Microsoft Access: Connect to PostgreSQL

Microsoft Access: Connect to PostgreSQL

System Category

Data Access

Source

Spatial Data Warehouse

Available since

2014

Organisation

image-20250918-155401.png

 

Download and Install PostgreSQL 32-Bit ODBC drivers

Download the Windows drivers from www.postgresql.org

Create an ODBC connection

  • From the windows desktop go to Start and type in ODBC.

  • Pick the ODBC Data Sources (64- bit) option.

Alternatively ODBC 64-bit Data Sources can be found here c:\windows\system32\odbcad32.ex

  • You should now see this dialog.

    image-20250918-151711.png

  • Pick the System DSN tab

    image-20250918-151943.png

  • Click Add...

    image-20250918-151800.png

  • Select the PostgreSQL ANSI driver and click Finish.

You should see the following:

  • Enter the details as follows:

    • Data Source: use an appropriate name

    • Database: see your client notes

    • Server: see your client notes

    • User Name: see your client notes

    • Description: n/a

    • SSL Mode: disable

    • Port: 5432

    • Password: see your client notes

Ensure that you press Test to make sure your connection is valid

  • Click Save.

Run Access

In this example we are using Access 2013. Select External Data > ODBC Database

Select 'Link to the data source by creating a linked table'

Select Machine Data Source and the name of the Data Source Name you have created.

In this example we wish to inspect the table used by the Logger application which is public.at_incidents.