Run-Time Error 13 Type Mismatch but works OK for me!
Posted on 2006-06-13
Whenever a friend tries to update a database (access2000) I have written he gets a Run-Time Error 13 Type Mismatch error. The code works fine for me on my laptop though. Does anyone have any ideas why??
We both are using the same version of MDAC (2.71.9030.0).
The DB is using Jet but I don't know how to check which version is installed on my laptop.
This is my Jet connection string
AConnection.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=c:\Orders.mdb;"
This is the code that updates the DB.....
AConnection.Execute "INSERT INTO table1 (a1,a2,a3,a4,a5,a6,a7,a8,a9,a10) VALUES ('" & Text1 & "','" & Text2 & "','" & Text3 & "','" & Text4 & "','" & Text5 & "','" & Text6 & "','" & Text7 & "','" & Text8 & "','" & Text9 & Text10 & "','" & Text11 & "')"