How to create linked tables only read only?

[jaryszek]

Hi,

I would like to create linked tables read-only.

I have Access FE and postgresql BE.


In postgresql there is a problem to giving special roles as read only.

So i think access will be the solution.

How to do it?

Best,
Jacek

[ranman256]

not in a regular Access link, but the ODBC setup to Postgresql may have it.
(control panel, admin tools, ODBC)
some have a flag for Read Only

if not, you can set all queries as snapshot (read only)
and all forms to read only.

[jaryszek]

thank you ranman256,

there is no something like read-only in ODBC
So i have to build firms to give accesses for each table.

Best,
Jacek

[Minty]

Can you not create a view to the table in Postgresql then make it only have select permissions?

[isladogs]

If the view doesn't have a primary key, update queries won't be possible.
Even so, the view can still be directly edited if users have direct access to it or to a query based on it.

However, users should only be able to work with data using forms.
So just make your form(s) read only either by using a read only record source or by locking the form controls

[jaryszek]

Thank you Guys.

I will try to do only forms to handle it.

Best Wishes,
Jacek