Form behavior after security implemented

[Angela]

I've implemented user-level security on the database and am testing it while
logged in as the 'editor' (full user) to make sure everything works. All the
queries are set to RWOP, user has Open/Run permissions on all forms, has
update/delete/insert permissions on certain tables that are updated thru
queries. I have two issues that I can't resolve:
- On one form, there is a unbound combox where the user can select a course
number. The AfterUpdate event on the combobox inserts the course name and
description into two other unbound text fields (by setting those fields using
cboCourseNumber.column(1) etc). This works fine when I am logged in as
myself (Admin) but not as Editor. What in the security parameters could
prevent those unbound fields from populating?
- One of the buttons on the Switchboard doesn't work when logged in as
Editor (it's supposed to pull up another form). The Editor has Open/Run
permission on all the forms.

Thanks for any and all help! I am so stuck.

Angela

 

[Angela]

I just noticed that when I click the button on the Switchboard, very briefly
in the lower left hand corner of the screen is "recordset not updatable" and
of course, nothing happens (the form that is supposed to open does not open).
The Switchboard was created with the Switchboard manager and I don't think
there is any recordset that is changed when clicking the buttons, and I have
other buttons that open other forms w/o error so unsure why this one button
wouldn't work.

 

[Joan Wild]

If you have all queries set to RWOP, then the users won't need any
permissions on the tables at all. You do, though, need to set the
appropriate permissions on the saved queries. From the sounds of it,
you haven't set permissions on the queries.

Joan Wild
MS Access MVP

 

[Angela]

Joan, thank you for your reply!

On the combobox issue:
The two fields that won't populate are based on an expression
(cboCourseNumber.column(1) and (2), not a saved query. Since posting, I
deleted my database and workgroup file, went back to my backup, went thru the
Security Wizard again. Inexplicably, this issue has resolved itself. I wish
I knew what had caused it but am happy it's no longer an issue.

On the Switchboard issue:
The Switchboard was created with the Switchboard Manager, and the button
that doesn't work opens another form. There are other buttons that open
other forms, and those buttons work fine. I do see, briefly, a "recordset
not updatable" msg in the lower left hand corner of my screen as I push the
button that doesn't work. Do you know if this error msg is referring to some
code on the Switchboard form, or on the form it is trying to open? The form
it is trying to open is just an info form based on a imple query and nothing
is being 'updated' as it is opened.

 

[Angela]

Ohhhh, this is so embarrassing. For some reason, I had a record save command
in the open event of the form (the one that wouldn't open from the
Switchboard). I must have copied the code from another part of my code (it
sets the specialeffects for the controls on the form) and didn't delete the
'save' part. Of course when I am logged in as a "reader", without permission
to update this query, it wouldn't work. And when it didn't work when I was
logged in as "Editor", I must not have had the proper update permissions for
the Editor on this query (as you suspected).

Thanks for your time.