Testing for Key Violation

[W Dean]

Hi,

I am trying to set up a database editing page for a table (list of users).
I'd like to set up the User Name as the primary key. I want to prevent users
from having the same user name. So should I check the user name exists
before writing a new record or should I attempt to write the record and then
check for a key violation. If its the latter how is it done?

W Dean

[Adde Chivas]

Try set the username as a Primary Key... And so the database wont accept
dubles....
W Dean <wd...@highlanduk.com> wrote in message
news:O4d3GD6f$GA.250@cppssbbsa04...