It is obvious why this is happening, the field I am trying to add or update is set as Unique and I'm trying to 'insert a duplicate key'. How can I prevent this? Can I catch the error in the ASP (JScript)? Or is it possible to find out if a field is unique (using an SQL statement or procedure?) before I try to add to the table (so I can at least do -some- client-side validation). The page(s) must run in IE4 -- I'm using Visual Interdev 6 for the JScript/ASP, Personal Web Server (for development), and SQL Server 7...<BR><BR>This problem has been driving me mad for over a week now! Any assistance would be gratefully received.<BR><BR>Keith Railton.