A client is receiving a "You don't have permission to read [REPORT NAME]" error message when attempting to launch a report in a MS Access database. When I go to the “Change Owner” tab under Tools > Security > User Groups and Permissions, the owner is <unknown>. If I attempt to change the owner, I get a "You don't have permission to change the owner of [REPORT NAME]." error message.
How do I reclaim the object so I can restore its permissions?
Can you assign "Open/Run" permissions to the report? Ordinarily, you shouldn't have to change the owner to allow a user group (or individual user accounts) Open/Run permission. However, I don't know if it will operate differently when the current report owner is unknown to Access ... I've never encountered that situation.
Will it let you re-assign the report owner when you log into the database with an account which is a member of the Admins group?
I ended up finding a copy of the database from a month ago and importing the inaccessible reports into a blank Access database file. Then, I imported the remaining database objects from the current copy of the database. Problem solved.
As far as I know, they have never used MS Access/MDW security on the database, so I suspect it's just a symptom of an old Access database that's ripe for a .NET/SQL Server migration.