Mail as primary key

[Nicolas93100]

I did not manage to define a text field (representing e-mail adresses) as the
primary key. Is it possible. All the values in this field are unique (no
duplicate).
I'm working on office 2007
Thank you

 

[Sprinks]

Nicolas,

Add the text field in Table Design View. Save the new definition *without*
designating the field as the primary key. Then add a unique value to each
record, afterwhich you can designate the field as the primary key in design
view.

You should be aware, though, that many developers prefer a simple numeric
primary key because it's faster. In most cases, the user doesn't need to
know or care about the primary key--you can display more meaningful text
using combo boxes.

Sprinks