Re: no read definitions on query

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

"Joan Wild" wrote:

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.



--
Joan Wild
Microsoft Access MVP

Adam wrote:
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" wrote:

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.


--
Joan Wild
Microsoft Access MVP

Adam wrote:
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



.

Relevant Pages

  • Re: Help - locked out of database
    ... IT checked all the permissions and everything seems to be ok. ... "Joan Wild" wrote: ... I have poured a year into this database - is there someway to recover this? ... You need, at minimum, modify permission on the folder. ...
    (microsoft.public.access.security)
  • Re: security only works on my PC
    ... I checked the permissions box and the Users group has no ... Open/Run and open exclusive on database object ... "Joan Wild" wrote: ... properly on the single mdb. ...
    (microsoft.public.access.security)
  • Re: Renegade Form
    ... "Joan Wild" wrote: ... the 'owner' and would need permissions on the source tables/queries ... For this query, you can create a RWOP query for each of the underlying ... Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: How to identify groups with database level permissions
    ... "Joan Wild" wrote: ... permissions available for Database and I have the administrators group ...
    (microsoft.public.access.security)
  • Re: no read definitions on query
    ... Try a Tools, Database Utilities, Compact and Repair. ... Unfortunately that will remove all permissions on the objects, ... I created a brand new query with one field ... forms/reports based on queries or tables? ...
    (microsoft.public.access.security)