Strange problem with access
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)