code to stop adding names twice in a DB

[Jel Student]

I need a code for an isvaliddata that will stop you from adding the same name and information to a database more then once.

[oracleguy]

Alright, cool but remember we are coders not telepaths, like what programming language and database you are working with would be a great help.

One way on the database side to prevent duplication of data would be to make a uniqueness constraint on your name column and that would cause any query that would insert the same data in to fail.

[Jel Student]

Sorry. Visual Basic 6.0 and MS Access 2003