Exact match using case-sensitive

[tamtf]

I have a table with ID's, some of which appear multiple times. Each instance of these ID's is spelled using a different combination of upper and lowercase. Access disregards each instance's case and thinks these ID's are duplicates. I need to create a relationship between two tables using the ID field as a unique field. Is there a VBA code available to do this?
Thanks for your help

 

[xlbo]

Apart from anything else, this is VERY bad practice - unique ids should be just that...unique and AFAIK (and I'm quite willing to be proved wrong) you are not going to be able to get Access to distinguish these. I would humbly suggest that you concatenate something to the end of the id's to make them actually unique. Even if you do find a way to make Access recognise the different cases, it's more than likely to cause you problems later down the line when you need to reference these ids for whatever reason
HTH
Geoff