We are running Access 2002 app, but our mdb files are still Access 2000.
I have imported data from our business system where the primary key is case sensitive - lowercase is unique from uppercase.
When I try to recreate this primary key in the database, it tells me I have duplication.
Is there anyway to force the primary keys to be case sensitive?
Thanks so much.......