How to Connect the Database to MS Access

I want to try to connect my panoply DB to MS Access using linked tables. I was imagining that I could download the ODBC driver from PostgreSQL and connect, no different than MySQL or SQL. However that doesn’t seem to be the case.

Has anyone done this successfully?

2 Likes

Hi there,

I don’t think that someone has tried to do such a connection. But it does look quite straightforward to do this connection. Can you email to support@panoply.io with some more details so a member of our team will be able to help you personally? At the end we will make sure to post here the actual steps taken to connect between MS Access and Panoply.

1 Like

Hi Alon - I was able to get this to work. It was the unicode driver + Admin Privs to save the changes to the registry.

image

2 Likes

I’m glad you got it working, Adam!