Users

microsoft.public.access.security

6 Apr 2005 9:07 PM

Stefan

I have a database on a shared drive on my server (2003).
It was strictly for viewing reports no data entry was
being done.

When I created the database I was under my logon
(Stefan) of which I am the administrator of the server
and of the datatbase. I then created a user account
which only had open/run (viewing properties).

At this time I am adding forms to enter data.

I updated the form security to allow the users full
access. However unless I log on to the server as myself
(Stefan) I cannot enter information into the form it is
all greyed out.

Basically I have an account on the server and in the
database REPORTS. which I would like to be able enter
info into the form. At this time only the administrator
can.

Do I have to remove all security and start from scratch?

Sorry for being long winded. Any help would be greatly
appreciated.

Stefan