need help with permissions

[gustin]

I have a database that I have not set any security on. We have used this
database for several years with no problems. Suddenly, I'm getting the error
message: "Record(s) cannot be read; no read permission on 'Peanut Combine'.
(Peanut combine is the name of a query.) I am the owner and administrator of
this database and have not made any changes to the permissions. Any ideas?
Thx.

 

[Joan Wild]

Someone has set some security on it, it seems. Can you open the database
and go to Tools, Security, permissions? In this dialog check what the
permissions are for this query for both users, and for groups. also check
the ownership tab and see who the owner is.

Post back with that information

 

[Chris Mills]

Since you claim you have not set any security, what happens if you recover one
of your recent backups to some temporary folder/file, and open it?

Either someone has set some security without your knowledge, or (at a pinch)
it "merely" became corrupted.

(The corruption suggestion might worry me more than hackers! esp. if not
caught early with backups)

Chris

 

[gustin]

Someone did mess with the permissions, however, after I reset them, the
problem persist. I have just re-created the necessary queries and won't use
the old ones I guess. Thank you for your help.

P.S. Chris, you are correct, I am talking about a machine that harvests
peanuts!