Limit Use on certain Desktops

[Affy]

Anyone know how i can limit the use of my Access database so it only works on one desktop, so if someone were to make a copy it would not work on any other desktop.

 

[wolfert]

I know there is an API to get the user name. You'd better search

http://www.allapi.net

to find if there is one to get the computer name (must be).

Private Declare Function w32_WNetGetUser Lib "mpr.dll" Alias "WNetGetUserA" (ByVal lpszLocalName As String, ByVal lpszUserName As String, lpcchBuffer As Long) As Long
Private Sub Form_Load()
'KPD-Team 1998
'URL:

http://www.allapi.net/

'E-Mail: KPDTeam@Allapi.net
Dim lpUserName As String, lpnLength As Long, lResult As Long
'Create a buffer
lpUserName = String(256, Chr$(0))
'Get the network user
lResult = w32_WNetGetUser(vbNullString, lpUserName, 256)
If lResult = 0 Then
lpUserName = Left$(lpUserName, InStr(1, lpUserName, Chr$(0)) - 1)
MsgBox "The user's Network Logon Name is " + lpUserName + ".", vbInformation + vbOKOnly, App.Title
Else
MsgBox "No user found !", vbExclamation + vbOKOnly, App.Title
End If
End Sub


Patrick