VIEW OR TRANSFER OWNERSHIP

Transfer Ownership of Objects

If you have Administer permission for a Table, Query, Form, Report or Macro, you can change the ownership of the object to another user or group.

1. Open the database.
2. On the Tools menu, click Security, and then click User and Group Permissions.
3. On the Change Owner tab, Microsoft Access displays a list of the tables, queries, forms, reports, and macros that are currently displayed in the Database window and the current owner of those objects.
4. Click an object type in the Object Type box, or use the existing object type.
5. From the Object list, click one or more objects with ownership that you want to change. To select more than one object, either hold down CTRL and click the objects or drag through the ones you want to select.
6. In the New Owner box, click the user or group account that you want to be the new owner of the object or objects.
7. Click the Change Owner button.

Note: If you change ownership of a table, query, form, report or macro to a group account, all users who belong to the group automatically receive the permissions associated with ownership of the object.

<-- For FB Posts without Images

Earlier Post Link References:

-->

MS-ACCESS Security Links.

1. Create a security user account
2. Create a security group account
3. Add users to security groups
4. Remove users from security groups
5. Delete a security user account
6. Delete a security group account
7. Create or change a security account password
8. Clear a security account password
9. Assign or remove permissions
10. Assign default permissions for new tables, queries, forms, reports, and macros.
11. View or transfer ownership of Objects
12. Transfer ownership of an entire database to another administrator
13. Permit others to view or run my query but not change data or query design.
14. Change default permissions for all new queries.
15. RunPermissions Property
16. Convert Microsoft Access 95 or 97 secured databases.
17. Convert a workgroup information file from a previous version of Microsoft Access.
18. Share a previous-version secured database across several versions of Microsoft Access

Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldEditEdit in GingerEdit in Ginger×