asked on Dealing with Case sensitivity in MS Access
Good morning,
I have a series of table which I need to incorporate into a MS Access DB. The unique key in the source tables are from a DB structure where case is also considered so, where my source data defines 12345AB and 12345Ab as unique records, MS access states these are duplicates.
Any suggestions on how to tell MS Access that these are indeed to different records?
I have a series of table which I need to incorporate into a MS Access DB. The unique key in the source tables are from a DB structure where case is also considered so, where my source data defines 12345AB and 12345Ab as unique records, MS access states these are duplicates.
Any suggestions on how to tell MS Access that these are indeed to different records?
Microsoft Access
Last Comment
Patrick Matthews
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Points awarded to both answers as they are both correct. A function can be used to determine differences in a field as related to CASE, however as this item is to be used as a KEY value, MS Access won't function to differentiate based on case.
A function can be used to determine differences in a field as related to CASE, however as this item is to be used as a KEY value, MS Access won't function to differentiate based on case.
Depends on what type of key you mean. If you mean as a primary key, the above is correct.
As a join key, it could work, as cap1 demonstrated:
SELECT *
FROM tbl1, tbl2
WHERE StrComp(tbl1.ID, tb2.ID, 0) = 0