no read definitions on query

[Guest]

The strangest thing started happening a few months back. I have user level
security on a database. Suddenly, for no reason I could discern, the
database was requring that every user have read permissions on every query in
the database, regardless of wheter or not the user tried to access the query.
The error message "No read definitions on qryActivity" pops up at login and
the database won't open. To fix the problem, I gave this particular user
read definitions for qryActivity. The next time the user logged in the
message "No read definitions on qryAppointments" pops up. Continue this
process through every query in the database in alphabetical orderfor every
user. Finally I just made a group with read definitions on every query and
added all users to that group. It works, but obviously this is not the most
secure solution. Has this happened to anyone else? What did I do to break
it (I take full responsibility), and what should I do to fix it? Thanks.

Adam

 

[Joan Wild]

I don't quite follow what you had set up previously. Are your forms/reports
based on queries or tables?

If queries, then the users need at least read data permissions in order to
read the data (in addition to Open permission on the forms/reports).

If you had no permissions on the queries/tables, then users wouldn't be able
to do anything.

 

[Guest]

Joan-

That is the strangest part. The query that the user "needs" permissions for
is not attached to anything that opens when the DB is opened. To double
check, I created a brand new query with one field in it, logged off as me and
logged back in as a different user. The exact message I got was "Could not
read definitions; no read definitions permission for table or query
'Query1'". I am at a loss.

Adam

 

[Joan Wild]

There may be some corruption at play.

Try a Tools, Database Utilities, Compact and Repair.

If necessary, you may have to create a new mdb and import all objects.
Unfortunately that will remove all permissions on the objects, however you
can use the tools at www.diaglenet.com to transfer the permissions over.
Look for dbutilities.

 

[Guest]

Joan-

I do a compact and repair pretty frequently so it probably isn't that. Oh
well, I guess I will have to bite the bullet and crete a new mdb. Thank you
for your time on this issue. I appreciate you and eveyone on this forum!

Adam