Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1778
  • Last Modified:

Run-Time Error 13 Type Mismatch but works OK for me!

Hi,

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 & "')"
0
wildarmsdave
Asked:
wildarmsdave
  • 3
  • 2
  • 2
  • +1
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what are the data types of the fields a1-a10?
0
 
wildarmsdaveAuthor Commented:
angelIII  - They are all text fields.

By the way, I've just got my friend to search his hard drive for Jet. He had the same dll version numbers as I did but was missing msjet35.dll. He's copied it to his system32 folder but it didn't fix the problem...
0
 
pootle_flumpCommented:
Just to be explicit - is the error on the line:

AConnection.Execute ....

??
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
wildarmsdaveAuthor Commented:
It must be as that is the only code behind the command button. I've tried the database on a few PC's at work (which are the same build/OS etc etc) as my friends (who also works with me) and I couldn't replicate the error.

I'm just wondering if he is using the same test database that I am which may explain things. I'll ask him when he gets back from lunch...
0
 
pootle_flumpCommented:
Hi

Is there a reason you are both writing to different databases?
0
 
leclairmCommented:
Perhaps he is trying to put a null value in one of the fields that doesn't accept nulls??
0
 
leclairmCommented:
Or perhaps he is trying to insert data that includes an apostrophe??
0
 
wildarmsdaveAuthor Commented:
angelIII 's comments got me thinking. My friend was using the same version of the test database but had been 'playing' with it and one of the data types had been incorrectly set. I'm just glad it was something simple!! Thanks to everyone for their help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now