User can not add data to form

3 Nov 2005 4:09 PM

CarlSprake

I have an access database and set up some user level security. As the Admin I
have complete access to everything. I have set up a user with exactly the
same rights as me. However, when I open the database as this user I can not
add data to a form. The form contains combo boxes. As this user I can click
on the combo box to show the drop down but when I click on an option, that
data is not inserted into the field on the form.

Please does anyone have any ideas? Thanks

3 Nov 2005 4:37 PM

Lynn Trapp

How did you set up the user level security? Did you use the wizard? Which
version of Access?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

Show quoteHide quote

"CarlSprake" <CarlSpr***@discussions.microsoft.com> wrote in message
news:9E61D41E-165E-4FD6-B657-12EF973823DE@microsoft.com...
>I have an access database and set up some user level security. As the Admin
>I
> have complete access to everything. I have set up a user with exactly the
> same rights as me. However, when I open the database as this user I can
> not
> add data to a form. The form contains combo boxes. As this user I can
> click
> on the combo box to show the drop down but when I click on an option, that
> data is not inserted into the field on the form.
>
> Please does anyone have any ideas? Thanks

3 Nov 2005 4:38 PM

Joan Wild

It sounds as though the user has Open/Run permissions on the form, but does
not have sufficient permissions on the recordsource of that form.

Is the record source a query or table? Check the permissions on that -
they'll need Insert permissions.

--
Joan Wild
Microsoft Access MVP

CarlSprake wrote:

Show quoteHide quote

> I have an access database and set up some user level security. As the
> Admin I have complete access to everything. I have set up a user
> with exactly the same rights as me. However, when I open the database
> as this user I can not add data to a form. The form contains combo
> boxes. As this user I can click on the combo box to show the drop
> down but when I click on an option, that data is not inserted into
> the field on the form.
>
> Please does anyone have any ideas? Thanks