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.

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


Show quoteHide quote

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
----------
PS (sorry I can't help myself) Most of the products I buy in the supermarket
now have a warning "may contain traces of peanuts!" :-)

Would that be a Combine Harvester for Peanuts? I better stop :-))

Show quoteHide quote

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!

Show quoteHide quote

Where is workgroup manager in access 2007?
restricted user level security
How to add the security back to the normal database?
Multi users in one form
Use Level Security lockout
splitting the database and securing the back-end file?
Help with
replication problems
RWOP and database permissions on backend
Can an Access database expire?