Re: [GENERAL] PostgreSQL and Access (via ODBC)

[Sean Weissensee]

Within Access, click file, get external data, link tables,

choose ODBC, select the postres driver,

select the DSN,

this will bring up a window to select tables from the db,

highlight the tables, click ok,

at this stage if a unique ID was not set in the postgre table a window will
appear to choose a unique id,
if Access does not get this you will not be able to add or update any
records.

Hope this helps,

Sean