security on network

G

Guest

I need to secure a database placed on a network. So far I have been unable
to split the database properly because of the network. So I need to do the
Security thing, The problem is that approximately 400 people have to be able
to make a 'request' or view a report on the database. I obviously cannot
track down every user and get their corporate log on IDs to make user groups
( a nightmare in administration). Can security be set so these 400 people
can use forms and see/print reports only.
I have searched through the posts and cannont find an answer or hints for
this.
 
J

jacksonmacd

Every instance of Access uses security. Every Access session for which
you do not explictly login to the database silently logs in as the
"Admin" user. Every Admin user is a member of the Users group.

The key to the solution is to apply user-level security and grant
permissions to the Users group for all the objects that you want
"anonymous" users to have access to, and deny permissions to the Users
group to everything that you want them locked out of.

The users will continue to use the workgroup file from their own
computer. You, as the developer, must create and use your own account
to create and edit the database file.

BTW - tracking down their corporate login ID would not provide any
benefit because Access cannot use that information.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top