case insensitive query in join

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi i have joined two tables on a field name on both tables.
when i want to turn on the data integrity it complains that some rows are
not matching. i realized this happenes because of the fact that some names
are uppercase in one table and same names are lowercase in the other.

how can i eliminate this problem.

thanks
sasan
 
hi i have joined two tables on a field name on both tables.
when i want to turn on the data integrity it complains that some rows are
not matching. i realized this happenes because of the fact that some names
are uppercase in one table and same names are lowercase in the other.

how can i eliminate this problem.

thanks
sasan
Click to expand...

That's odd. Are these Access tables stored in a .mdb file? Or are they
in some other database engine such as SQL/Server? JET joins are case
insensitive and cannot be made case sensitive, so I doubt that the
error is due to case!

John W. Vinson[MVP]
 
Access isn't case sensitive, so it's extremely unlikely that that's the
cause of the problem. Check to make sure that there isn't some other
difference than the case (number of spaces, etc.)
 
Hi John,

yes its all in Access database, any thought?
Click to expand...

Then the error is not due to case. It might be a damaged index; try
Tools... Database Utilities... Compact and Repair. Or it might
actually be a value in the "child" table which does not exist in the
"parent"; try using an Unmatched Values query to find such records.

John W. Vinson[MVP]
 
Back
Top