Two External Tables opening READ ONLY in a query

[GregoryWest]

I am having a problem, I have two external tables, on a PostgreSQL server, both tables are read/write but when I make a query the query ends up being readonly. Why is this happening? How do I fix this?

 

[jdraw]

Hmmm???
Perhaps you do NOT have write authority in Postgres???
I haven't used Postgres, but with other database systems you have privileges at that database, and that usually controls what your are allowed to read or write.

Have you talked to the Postgres dba?
How exactly are you accessing these tables?
What is the SQL of the query?
Union queries are not updateable.

 

[boerbende]

When you double click on the linked table, you are allowed to write directly in the table? If yes, you have access rights.

Indeed as JDraw says it can be dependent of the query. Union, crosstabs, or grouped by queries are not updatable

 

[GregoryWest]

I can update either of the tables independently in Access. As for a union, I do have the two tables in a JOIN. Do not think I am using the UNION verb, unless Access is doing that behind my back.

When I display the SQL code is Access this is what is shown:
SELECT PageCount.*, Copiers.Description, Copiers.Assembly, Copiers.Customer, Copiers.CycleMonths, Copiers.PONumber, Copiers.eMailUser, Copiers.in__Service, Copiers.ContractCode, Copiers.InService
FROM Copiers RIGHT JOIN PageCount ON Copiers.Copier = PageCount.Copier
WHERE (((PageCount.Exported)="False") AND ((PageCount.Active)="False") AND ((PageCount.ExportDate)=#1/1/1980#));


So I do have a right join, but not a union, or am I reading this wrong?