Crescencio,

How can I check that my insert succesfully executed.

Here is the code for my insert:

********************************************************************
cSQL = "INSERT INTO Training ( course, name , [date] ) ;
Values ( " + "'" + lcCourse + "' , ;
" + "'" + lcEmployeeName + "' , ;
" + "'" + ldDate + "' )"
oCn.Execute(cSQL)
*******************************************************************


Also do you know how to close the connection.

Here is how I created the connection :

***********************************************************
lcMDBStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=l:\ehs\data\eh&s.mdb;"
oCn = Create("adodb.Connection")
oCn.Open(lcMDBStr)

*********************************************************

Thanks in advance,
Sergio