Restrict ODBC access to read only on AS400

Is there a way to restrict ODBC access to read only on AS400, I have a few users who use Access link tables to AS400 files. I don't want them to be able to update data via Access, I know I can set the ODBC connection to read only access but is there any way I can do something on the AS400 to do this as theres always the possibility of the users changing the access on the ODBC connections.
Thanks,
Carla

Solution: Restrict ODBC access to read only on AS400

Hi
an easy way is to create a logical file over the physical, create an authorisation list over that file that only has read only access and access that file via ODBC.

If the file has a duplicate access path there is no additional overhead to the 400.

Dave