Type 13 mismatch error

[zak88lx]

Hello,

We are running a custom Visual Basic program which uses Access databases. The problem resides when I query certain entities with VB program to retrieve data from access databases, the majority work but certain ones come back with type 13 mismatch error message!
I have checked out the tables to see if anything stands out but I really don't know what to look for...

Can anyone give me some direction?

Thanks,
Zak

 

[bjackson]

make sure the data types are the same
maybe some numbers are stored as text or vice versa

 

[zak88lx]

Re: make sure the data types are the same

I checked the design view of tables and they are all Double for format. I checked to ensure that no zeroes were actually letter o's. I normally append data to the tables from delimited text files which were originally excel files...

Zak

 

[Shep]

If it occurs every time when using the same function in the VB frontend, maybe the SQL in the frontend query is faulty. You may not be able to do anything about it at all.