July 7, 2010 at 10:38 pm
hi,
Iam developing a database with Access as front end and Sql Server 2005 express as back end. It should be used in a multi-user environment. Some users should have access to all details and some don't.
Which would be the best option in this situation (ms access project or database?)
I am new to Sql. I want the easiest method of implementing security.
please help
Thanks in advance
August 3, 2010 at 1:13 pm
Hi I have same problem, but SQL is 2008 express.
I created table with (user_name,password- hash,column admin - boolean)
I need solved how to store that user is entered and have admin access.
Maybe used temporary table where will info about that user entered coorect password...
August 4, 2010 at 1:41 pm
I've used the following to restrict user access. Usually by locking controls on a form or making things invisible
Dim stUser As String
stUser = GetLoginName
Select Case stUser
Case "DAVID", "KATHY", "JO", "Micheal"
'allow access
Case Else
'restrict access
End Select
Public Function GetLoginName() As String
' Returns the network login name
Dim lngLen As Long, lngX As Long
Dim strUserName As String
strUserName = String$(254, 0)
lngLen = 255
lngX = apiGetUserName(strUserName, lngLen)
If (lngX > 0) Then
GetLoginName = Left$(strUserName, lngLen - 1)
Else
GetLoginName = vbNullString
End If
End Function
GetLoginName returns the current users windows log in. I also have a table with columns for username and boolean columns for privileges such as "Can_Sign_Quote", "Can_Sign_PO". So I can check that table to see if user x has privilege y.
This works for me because I only have a few users and "real security" isn't a requirement. It's mostly used to prevent people from seeing things they don't want or need to see.
August 4, 2010 at 3:31 pm
On small scale, I've used something similar to dschubel, but I also used a bit field and bitmasks for access control. Makes a clean select case that doesn't have to be maintained as users change.
Larger scale I use AD group memberships.
August 5, 2010 at 10:55 am
kiranmai.gompa (7/7/2010)
hi,Iam developing a database with Access as front end and Sql Server 2005 express as back end. It should be used in a multi-user environment. Some users should have access to all details and some don't.
Which would be the best option in this situation (ms access project or database?)
I am new to Sql. I want the easiest method of implementing security.
please help
Thanks in advance
The best way is to define and specify your security settings in the SQL Server.
And then build your front-end MS Access ADP project directly linked to that SQL Server with Windows Authentication.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply