User Access - How do I grant RW access to records

[Maturi]

Hi,

I'm trying to setup a database with a number of users. I can see how to grant read/write access to tables and forms by user. But is there an easy way to define RW access to individual records in a table ?

Thanks

 

[JerryKlmns]

Nope!

But you (a user in the admins groups) could revoke Read rights to the table, create a query to filter records! And even show less fields!

SELECT Field5, Field47
FROM myTable
WHERE FilterField = True
WITH OWNER ACCESS;