Printable View
My problem is that everytime I try to open one of my tables in SQL database I get the following error:
Type mismatch in JOIN expression. (Error 3615)
Can you help me how to fix this issue? According to me everything should be fine. The error message says there is some wrong statement but it doesn't mention where the problem occurs. This error forbidden me from opening my table. So I need your help!
A JOIN expression is attempting to join two tables on fields of incompatible data types. For example, you will get this error if you attempt to join a Memo field with a Text field.Quote:
Type mismatch in JOIN expression. (Error 3615)
If you're opening a table, there is no joins used anywhere. However if you're trying to open a query that joins two tables, there is where you are having the issues.
I really do not understand what this error message says, where the problem lies and help you much. However what I predict is that you are having a query which contains one or more joins and among them one is bound to incompatible fields.
This error message certainly doesn't occur when you join fields that have the same datatype. However if you disobey this rule, the result is this error. The 'type mismatch' message is correct and this would force you to change the datatype in your tables or modify your query.