Home:ALL Converter>How to query PostgreSQL database table from Access?

How to query PostgreSQL database table from Access?

Ask Time:2015-11-19T19:37:25         Author:Salman

Json Formatter

I am very new to SQL, MS Access & PostgreSQL. So this might be a very silly question but somehow I can't figure it out. I'm trying to run SQL queries in access and my data is in a PostgreSQL database table which was linked to access by my colleague earlier. When I make this simple query why do I get an error that the table doesn't exist? Is the syntax different for linked database tables? Or is the link not yet established?

screenshot

Author:Salman,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/33802845/how-to-query-postgresql-database-table-from-access
yy