Point well taken on IDENT_CURRENT.

Problem Solved!  I was running some code outside a sub that was deleting the newly created record.  DUH!

Thanks for the assistance!

Thanks but..I cant do that because I get an error saying I cant assign values to a variable within an INSERT statement.

This is really frustrating...no matter what I do to...

I should add that I am using MSDE and calling the procedure from ASP. The procedure appears to run fine in my access front end but does not work when called...