How to query PostgreSQL database table from Access?

Question

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?

Andre · Accepted Answer · 2015-11-19 11:50:30Z

2

You have created a Pass-Through query. This query is executed on the server, not in Access, so you need to use the original table names from the PostgreSQL database.

So it's not FROM public_tb_change but FROM tb_change.

Or maybe FROM public.tb_change, if public isn't the default schema.

I advise to rename your linked tables to the original name (remove public_), that makes things much less confusing. The schema name is automatically added by Access when linking the tables.

answered Nov 19, 2015 at 11:50

Andre

27.7k7 gold badges43 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Salman Over a year ago

Removing 'public' from the table name and redoing the query with that new table name did the trick. Thanks!

Collectives™ on Stack Overflow

How to query PostgreSQL database table from Access?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related