Why don't you just query the Access table for the record you just inserted?



>Hello everyone,
>
>I am inserting recods to an access database and I need to check if the records have been inserted succesfully. Can anyone tell me how to do that.?
>Here is the code : The code is located in the Click event of a command button within a form.
>
>
>*-- Insert a record to a VFP table
>lcNewID = newid("training")
>INSERT INTO training (training_id , name , date ) ;
> VALUES ( lcNewID, CourseList.name, Thisform.txtTrainingDate.Value)
>
>*-- Inset a record to an acces table
>lcCourse = CourseList.Name && get the name from a VFP table called CourseList
>lcMDBStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=l:\ehs\data\eh&s.mdb;"
>oCn = Create("adodb.Connection")
>oCn.Open(lcMDBStr)
>oCn.Execute("INSERT INTO Training ( name );
> Values ( " + "'" + lcCourse + "' ) ")
>Thisform.Reset()
>
>
>*******************************************************************************
>Thanks,
>Sergio