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
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
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.
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
Can you not create a view to the table in Postgresql then make it only have select permissions?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
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
Thank you Guys.
I will try to do only forms to handle it.
Best Wishes,
Jacek