G
Guest
I have split my db into BE/FE. There are no permissions assigned on tables
on BE to group AppUsers. This group has full permissions on FE to tables,
forms, queries. I have converted all my tables to rwop queries and use them
in all my forms. It has been successful except for a combo box lookup table.
I have two forms - an update form and a search form. Both forms have a
combo box linked to the same rwop query. Both the update form and the search
form are opened from a main form. I am able to open and lookup(use) the
combo box value in the update form. When I try to open the search form I
get, "Record(s) cannot be read. No read permission on tblVendor".
Don't understand why the rwop (lookup) query works fine on one form and not
the other.
Thank you,
LBN
on BE to group AppUsers. This group has full permissions on FE to tables,
forms, queries. I have converted all my tables to rwop queries and use them
in all my forms. It has been successful except for a combo box lookup table.
I have two forms - an update form and a search form. Both forms have a
combo box linked to the same rwop query. Both the update form and the search
form are opened from a main form. I am able to open and lookup(use) the
combo box value in the update form. When I try to open the search form I
get, "Record(s) cannot be read. No read permission on tblVendor".
Don't understand why the rwop (lookup) query works fine on one form and not
the other.
Thank you,
LBN