On Sep 15, 2:24 pm, "Jerry DePlancke" <jdepl...@ellijay.comwrote:
A keyed field in one of my tables cannot have duplicates. This is easy to
specify.
But I need the ability to have variations in the case of the fields.
ie I need a keyed value of "abc" to be different than a key value of "ABC"
or "AbC".
I don't see any way of specifying this.
I create a new mdb "db1.mdb".
I copy the table Employees from the Northwoods sample mdb to my new
mdb.
I change the lastname index to "unique".
I try to change Andrew Fuller's last name to DAVILIO. I can't. Nancy
Davilio already exists in the table.
I run this line of code.
CurrentProject.Connection.Execute ("ALTER TABLE Employees ALTER
LastName Binary (20)").
I change Andrew Fuller's last name to DAVILIO.
It is changed.
DAVILIO is sorted before Davilio.
Are there problems with binary fields? I have used them for ten years
or so and never found any. But others may have. Still others don't
trust anything not recommended by Microsoft or initiated by
themselves. You will make up your own mind, I expect.