Im not so new in VB, but my brian was totaly broken...in VB6, access database, DAO, I have one main and one buffer table. Main table have all fields as buffer one and few more. In buffer table, I write few records, 5,10...and after finish adding any new records, I need to transfer or copy all records from buffer table in main one...HOW??? I try everything, search everywhere...cant find anything...Anybody can help me ??? thanks in advance.

If the process allows, after each single record is written, I would get the return ID and execute an Insert SQL statement into the target table.

INSERT INTO tblTarget(Field1,Field2,etc..)

SELECT Field1,Field2,etc.. FROM tblSource WHERE ID = @@IDENTITY  --Which should be the ident of last record entered