Security

[Cloey]

I created a form that I would like all managers to access. It contains links
to an access database for the dropdowns. Managers are not having any
problems with forms that do not utilize my access database. They are only
getting the error with forms that utilize the access database drop downs.
I've placed the access database on a shared drive and given users full
control. I've been to the link about a Security Error Opening a Managed Code
Form. In reviewing the Security error message it appears that I would have
to change all managers security access to access the form. Is that correct?
That just isn't possible for me. Is there another solution?
I like being able to edit the information in the access database and having
the forms automatically pull the updated information and really don't want to
have to edit the form each time there is an update. Is there a better way?