Hi,

I make a program using an access database. When I execute the program on my computer (Windows XP Pro) I have no problem but when I try to run the program on my other computer (Windows Me) I get an error when I try to add a new record.

The error that I get is :

Run-time error -2147217887 (80040e21)
A multi-steps OLE DB operation has generated error.

I thinked it can be a dll error so I updated :

MDAC (2,7)
Jet 4

and I didn't work.

Here is my code :

Set Cn = New ADODB.Connection
strCn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\bull.mdb;Persist Security Info=False"

Cn.Open strCn

Set Rs = New ADODB.Recordset
Rs.Open "bulletin", Cn, adOpenKeyset, adLockPessimistic, adCmdTable

Rs.AddNew
Rs!Numero = txtNo.Text
Rs!Description = txtDescription.Text
Rs!Marque = cmbMarque.Text
Rs!Chemin = txtChemin.Text
Rs!Operation = txtCode.Text
Rs!Temps = txtTemps.Text
Rs!Plainte = txtPlainte.Text
Rs!Panne = txtPanne.Text
Rs.Update

anyone can help me, please
(sorry if I make some mistakes, english is not my maternal language)