Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set security level for a database

Status
Not open for further replies.

sonikudi

Technical User
Sep 9, 2007
81
US

Hi,

I need to setup some sought of security for my Database..the database can be viewed by anyone but only some users should be able to add, delete or edit a table or any record in the table. This is a backend Db and the front end resides in the same folder. i tried using the security control wizard..but it didn't quite work and is very confusing!..Is there a better way to do this? Or if anyone can guide be through the security wizard on how exactly it works and what i need to look out for?

Any help will be much appreciated. thanks
 
Hey Remou,

Thanks a lot for the great resource. I was able to secure the database but ..i am trying to delete the 'Admin' account under the 'Admins' user group as i have specified another account with a different name as Admins. Access won't let me delete this account.

The reason i want to delete the 'Admin' account is , from my understanding, of readin an FAQ on the MS website is that..by default when anyone opens the access Db they log in as Admin user. I just want to make sure that anyone else who does not have an account in my created workgroup can't either add themselves in my workgroup or login as an admin.

Also this Db has a front end..that is used to add info to the Db..Will the security changes made to the Db also affect other users not in my workgroup from using the front end to add info to the secured Db?

Thanks!
 
sonikudi,

While someone maybe able to log in as Admin in their workgroup, that Workgroup does not have your Admins group and therefore that instance of Admin is not a member of Admins. Although, you may choose to remove the Admin user from the Admins group anyway.

Understand that PID's, Groups, Users, Group Membership and passwords all live in the workgroup file and not the MDB.

Security in an MDB is specified with the PIDS so a workgroup with the same PID as the one that secured the file could gain some access.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top