ms 2010 security

[viwaltzer]

I'm trying to find some documentation on how to set up the security and so far I'm getting nowhere.

I need to be able to have users logon with an id and password. I can build a user table and logon form, but does ms have anything in Manage Users & Permissions area that I can use? If I build the form, how do I get it to be the first thing that opens when they enter the system?

Most of the users will use the same computer with the same logon name, so I can't use the user name they logon with to the computer.

I need to limit each user to the records for just their event. I have all the events in the same tables. Power users should be able to see all events, but not change db design.

The limited users should not be able to open a table or alter data outside the forms I have built for them.

Any suggestions would be much appreciated. I'm a newbie to access and would love an easy, straightforward, easy to follow solution.

Thanks much :banghead:

 

[davies107]

having the same problem with you also. it is like, MS-Access lacks on security side. anyone can edit or change the database if they know something about MS-Access.

will keep an eye to this thread for some answers.

 

[davies107]

i have found this by searching the forum:

http://www.access-programmers.co.uk/forums/showthread.php?t=234296

nice tips though...

 

[Galaxiom]

If you have all users with the same login there is nothing that is going to be really secure using Access.

Access simply isn't secure. They took away ULS in 2007 because it was far too easy to break and just gave people a false sense of security.

Access passwords are not much use either. They can be broken. Someone can take away a copy of the file and hack it at their leisure.

If you link a password protected backend the password is stored in plain text in the front end in the Connect property of the tabledef.

The only way to really secure data is to use a database server as the back end and have separate user logins on a domain.