MS Access Frontend

Jason L. Amerson <drjason@alphagenius.org>

From: "Jason L. Amerson" <drjason@alphagenius.org>
To: "PostgreSQL" <pgsql-general@lists.postgresql.org>
Date: 2019-11-29T17:23:14Z
Lists: pgsql-general

I am trying to setup MS Access as a frontend so that it would be easier on
my wife and children to interact with PostgreSQL. I looked online for some
tutorials but the ones I found are out-date or only pick up after Access is
connected to PostgreSQL. I was wondering if someone knew of some updated
material that they could point me to or maybe walk me through it. I have
used Access quite a bit years ago and things have changed since then. I know
I must install the ODBC drivers, which I have already done. I have already
setup the DSN and I clicked on test and it says everything is fine. I know
that my next step has something to do with Linked Tables in Access, but I am
not sure how to set it up. I guess that is where I start to need help. The
client computers using the frontend will be running Windows 10 and Office
365, both are updated to the latest versions.

 

Thank you,

 

Jason L. Amerson