How do I connect to a PostgreSQL database using MS Access 2000 ?
Posted on 2004-08-17
How do I connect to a PostgreSQL database that is resided on a
Linux computer using Microsoft Access 2000 on Windows ?
Essentially, I am using Access 2000 as a front-end and PostgreSQL as a back-end.
I am using Access 2000 to facilitate complex query using the graphical method.
Please show it to me step by step how to do it. I think I need to use
ODBC that is built-in to MS Access 2000.
Location of PostgreSQL database:
Name of PostgreSQL database: