DataBase RESOLVED

[Blacknight]

dim a as adodb.recordset
Dim usersDB As ADODB.Connection
 
Private Sub Form_Load()
Set usersDB = New ADODB.Connection
usersDB.Open "dsn=DATABASENAME;"
 
Set a = New ADODB.Recordset
usersDB.Execute ("update FIELDNAME where)
'a.fields(number) I know that this line gives me the value of the 
'field however i don't know how i can find the field's name
'lets say that i want to print all of my table's fieldls' names
'in a loop How can i do this? i want to use it to update many cells
'as shown above (FIELDNAME)

Thank you,
Blacknight