|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
security on networkI 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. 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. On Fri, 14 Sep 2007 07:22:07 -0700, Camilady <Camil***@discussions.microsoft.com> wrote: >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. > jackmacMACdon***@telusTELUS.net remove uppercase letters for true email http://www.geocities.com/jacksonmacd/ for info on MS Access security  |
|||||||||||||||||||||||
Other interesting topics