Re: no read definitions on query
- From: "Joan Wild" <jwild@xxxxxxxxxxxxxxxx>
- Date: Tue, 14 Mar 2006 17:37:51 -0500
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
.
- Prev by Date: Re: Security over a Network
- Next by Date: Re: Picking authentication when linking Access to SQL Server
- Previous by thread: Re: Security over a Network
- Next by thread: Re: no read definitions on query
- Index(es):
Relevant Pages
|
Loading
