Resolved... tks!

in this mdb are 2 table DATI and MERCATI.

i want to loop all values in PROVA2 from table DATI and matching in PROVA8 of table MERCATI return the related value of PROVA5 and insert in table DATI in PROVA21...

i just use this piece fo connection

Dim conConnection As New ADODB.Connection
Dim cmdCommand As New ADODB.Command
Dim rstRecordSet As New ADODB.Recordset

conConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\APPLICAZIONI\DB_PAST_DUE.MDB;Mode=Read|W rite"
conConnection.CursorLocation = adUseClient


in the mdb example are only a few list of records in real mdb have 985.478 records in PROVA2.