Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I implement field-level or row-level security on my tables (RWOP or queries with Run Permissions set to Owners)?

April 26, 2017field-level implement owner permissions queries row-level run rwop security tables

0

Posted

How do I implement field-level or row-level security on my tables (RWOP or queries with Run Permissions set to Owners)?

1 Answer

0

Posted

. The creation of a new attachment can be implemented either via DAO by setting the Connect property of a TableDef object or by use of the TransferDatabase macro action. If you connect to a table by using the menus, you need Read Design permissions, but if you connect through code to reset the Connect property, you don’t need any permissions – the error returned in your module code is ignored and the table is linked anyway. If you use the TransferDatabase macro action, you need Read Designpermissions on the back-end tables. When using the Linked Table/Attachment Manager add-in, you must have Modify Design permission on the front-end table and Read Data on the back-end table.