In SQL, I can run an action query on a dataset "WITH OWNERACCESS OPTION" to get around security limitations on a user (skip example if you know what i'm talking about).
User belongs to Sales group... sales group does NOT have DELETE permissions on tblInvoices. The user cannot, therefore, delete any invoices. However, if I create a delete button and attach a query to it, tagging the "WITH OWNERACCESS OPTION" onto the query, this user can now delete a record.
If I have a need to use "RunCommand acCmdDeleteRecord" instead of a query (i have my reasons - not worth going into right now), how can I still get around the security limitation. Is there an equivelent "...OPTION" in the DAO/ADO 'world'?