1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
|
Private Type Un_Connecte
' --nom PC
PC(1 To 32) As Byte
End Type
Public Function Pc_Connect(strBdd As String)
On Error GoTo Err_Pc_Connect
Dim intLDB As Integer, i As Integer, strChemin As String, Nom_PC As String, utilisateur As Un_Connecte, _
db As Database, strTemp As String, strSQL As String
DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * FROM T_User;"
strChemin = Left(strBdd, InStr(1, strBdd, ".")) + "LACCDB"
intLDB = FreeFile
Open strChemin For Binary Access Read Shared As intLDB
Do While Not EOF(intLDB)
Get intLDB, , utilisateur
With utilisateur
i = 1
Nom_PC = ""
While .PC(i) <> 0
Nom_PC = Nom_PC & Chr(.PC(i))
i = i + 1
Wend
End With
If Len(Nom_PC) > 0 Then
DoCmd.SetWarnings False
DoCmd.RunSQL ("INSERT INTO T_User (COMPUTER_USER) VALUES('" & Nom_PC & "');")
DoCmd.SetWarnings True
End If
Loop
Close intLDB
Exit Function
Err_Pc_Connect:
MsgBox err.Number & vbCrLf & err.DESCRIPTION, vbInformation, "Erreur"
Close intLDB
End Function |
Partager