ACC2000: Can't Change Ownership When RunPermissions Set to Owner's (208929)

MORE INFORMATION

To change the ownership of a database object, you must have Administer permission for the object. You can change your permissions on the object if you are logged on as the object's owner, as a member of a group that has Administer permission on the object, or as a member of the Admins group in the workgroup in which the database that contains the object was created. If you cannot change your permissions on an object, see your workgroup administrator or the object's owner.

NOTE: Even if you satisfy all conditions in the previous paragraph, you still cannot transfer ownership of a query if its RunPermissions property is set to Owner's.

Steps to Reproduce Behavior

1. Start Microsoft Access and log on as the Admin user.
2. Open the sample database Northwind.mdb, and then open the Current Product List query in Design view.
3. Using the right mouse button, click the query, and then click Properties on the menu that appears. Set the query's RunPermissions property to Owner's, and then save and close the query.
4. On the Tools menu, click Security, and click User and Group Accounts. Click the New button. Create a new user called Joe, and make him a member of the Users group. Click OK.
5. On the Tools menu, click Security, and click User and Group Permissions. Click the Change Owner tab.
6. In the Object Type box, click Query, and click the Current Product List query in the Object box. In the New Owner box, click Joe. Click the Change Owner button. Note that you receive the message:

   You don't have permission to change the owner of 'Current Product List.'