TRANSFER OWNERSHIP OF DATABASE

Transfer Ownership of Database.

Start Microsoft Access by using a secure workgroup that contains the user account that you want to own the database and its objects.

1. Log on by using that account.
2. Create a new blank database.
3. Import all of the objects from the database that has the ownership you want to change into the new database.

Note: To import a database, you must have Open/Run permission for the database and Read Design permission for its objects. To import Tables you must also have Read Data permission. If you have permissions for some tables, queries, forms, reports, and macros but not others, Microsoft Access imports only those objects for which you have permissions.

<-- 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