In this article, we describe an efficient way to transfer the ownership of an Object in MS Access database.
It is important for users to understand and properly use the method of transferring ownership of any given Report or Table etc. in an MS Access database, in order to increase efficiency in the business. By transferring ownership, users can easily transfer information without using any external devices or software like pen drive sharing or email to transfer the data, thus reducing chances of generating a corrupted mdb file.
Users can transfer access of multiple Access objects to one or more users. They can even transfer ownership rights of any object to all the members of a particular group. This easy and instant exchange of rights and accessibility can be used to work on specific client projects, and more.
Ownership Rights and Other Factors
The owner of a database or a file has full access to accept or deny access of any user to that resource. Note that the Object administrators can change these settings anytime, however, new owners are eligible to operate these administrative rights if they have administrators’ permission to use the Database. The owner is the only user who has the authority to block or lock out a non-administrator user from accessing the data.
The ownership rights of an Object can be transferred in many ways:
- Current Owner can use his/her authority to transfer rights to new groups or users.
- A member of Administrator group can take up ownership, and then transfer it to other users.
- Users with ‘Take Ownership permission’, on a file can also take ownership of the Object on that file.
Steps to Transfer the Ownership of an Object in MS Access
Note Users can only use these steps to transfer ownership of an Object to another user if they have administrator’s permission or access to the Table, Report, Form or Macro.
- Step 1: Select and Open the Database whose ownership you want to transfer.
- Step 2: Go to the Tools menu, and click on Security, then select User and click on Group Permissions.
- Step 3: Select Change Owner Tab, which will display a list of MS Access tables, queries, reports, macros and forms that are available or are currently displayed on your Database windows. This will also include the list of all the current users or owners of these objects.
- Step 4: Now users need to select the object type from the Object Type Box. Users can also use the existing object type if it meets their prepared requirements.
- Step 5: Go to Object list, and select the objects whose ownership you want to change or transfer. Users can select more than one object, by holding CTRL, while selecting or clicking on multiple objects.
- Step 6: Now users can click on the group or users, in New Owner Box, whom they want to grant the access and ownership of the selected Objects or object.
- Step 7: Once you have selected the objects and new owners, complete the transfer by clicking on Change Owner Button.
If a user changes the ownership of any table, query, form, macro or report into a group account, all the existing users belonging to that group will automatically receive the permission to operate, access the database, and will be associated and considered as the owners of that Object.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including recover mdf and excel recovery software products. For more information visit www.datanumen.com