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

[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.

 

[Keith Wilby]

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.

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

Keith.
www.keithwilby.com

 

[Joan Wild]

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?

 

[tbl]

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

Keith.
www.keithwilby.com

Jeez! You and Joan both nailed it for me. I forgot to give
permissions on the query!

Thanks. Hopefully today will be a better brain-day...

 

[tbl]

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?

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!