Is there a way to authenticate a user in the ms-access database?

Question

I have an MS-access database. But it is on a shared drive. And it requires that only a certain number of people use it. Is there a way to authenticate a user?

Answer 1

Since access depends on the file, why not create a folder on the shared drive and assign access rights to the appropriate people.

Answer 2

, , "" > "" > " ". , Access.

Answer 3

. .

- .

, , .. .

Answer 4

Access 2007.

Access 2007:

• ()
• , Office Access 2007

Answer 5

, , ?

Answer 6

VBA. Form_Open sub API- Windows, , . "", , , Access.

'    Dim As String   Dim AuthorizedUser As Boolean   user = UCase (CurrentUser())

AuthorizedUser = True
Select Case user
    Case "USER_A":
    Case "USER_B":
    Case "USER_C":     
    Case Else: AuthorizedUser = False
End Select

If AuthorizedUser = True Then
   MsgBox "Welcome authorized user " & user
Else
   MsgBox user & "is not Authorized. For access to this database contact User_A"
   DoCmd.Quit
End If

Answer 7

:

• . , , Access .ldb, (.mdb).

• "" Access Sql... SQL . , . SQL, SQL, (, ///etc).