Query-based Combo Box -- No Permissions (?)

  • Thread starter Thread starter tbl
  • Start date Start date
T

tbl

In an Access 2000 / 2002 db, a user from a group with
permissions to enter/edit data on all forms, and where all
querys are RWOP, I'm still having trouble with a combo box
fed by:

SELECT qrySpecies.SpCode, qrySpecies.CommonName,
qrySpecies.OtherName, qrySpecies.SpId
FROM qrySpecies
WHERE (((qrySpecies.SpCode) Not Like "any"))
ORDER BY qrySpecies.SpCode
WITH OWNERACCESS OPTION;

I get the error:

"Record(s) cannot be read; no read permission on
'qrySpeciescbo_NoAny'."

Stuck again!
Any help appreciated.
 
tbl said:
In an Access 2000 / 2002 db, a user from a group with
permissions to enter/edit data on all forms, and where all
querys are RWOP, I'm still having trouble with a combo box
fed by:

SELECT qrySpecies.SpCode, qrySpecies.CommonName,
qrySpecies.OtherName, qrySpecies.SpId
FROM qrySpecies
WHERE (((qrySpecies.SpCode) Not Like "any"))
ORDER BY qrySpecies.SpCode
WITH OWNERACCESS OPTION;

I get the error:

"Record(s) cannot be read; no read permission on
'qrySpeciescbo_NoAny'."

Stuck again!
Any help appreciated.
Click to expand...

Have you granted this user read permissions to 'qrySpeciescbo_NoAny'?

Keith.
www.keithwilby.com
 
Is the combo fed by a SQL statement? If so the WITH OWNERACCESS OPTION is pointless. Is qrySpecies a RWOP query? Does the user have read data permissions on qrySpecies?

The message is referring to qrySpeciescbo_NoAny - what is that? Is it a query used in qrySpecies? What permissions does the user have on it? Is it a RWOP query?
 
Is the combo fed by a SQL statement? If so the WITH OWNERACCESS OPTION is pointless. Is qrySpecies a RWOP query? Does the user have read data permissions on qrySpecies?

The message is referring to qrySpeciescbo_NoAny - what is that? Is it a query used in qrySpecies? What permissions does the user have on it? Is it a RWOP query?
Click to expand...


Thanks Joan, you nailed it (again!). I forgot to assign
permissions to the query!

The smarter I *think* I am, the dumber I *really* am!
 
Back
Top