I'm in the process of moving over from Ms2000 to SQL, I'm using a ms adp as my front end. What my problem is that I've got a table called sessions and this as a PK but this allows duplicates. When i run a sproc in a form it works but i get a ms warning box "Duplicate Key was Ignored" with an OK button. Is there anyway to stop this I've tried docmd.setwarning false but it does not do anything, unless i'm putting it in the wrong place. Also because I'm new to SQL is there anything you can put in the sproc to stop the warning message.
Hope someone can help a new SQL convert.
Hope someone can help a new SQL convert.
