>> For what it's worth,I ended up making my insert routines stored procedures and specifying the PK as an output parameter.

IMO, this is the better approach. Especially the user of the OUTPUT parameter to return the value.

>> Not what I wanted to do in all cases ...

Why not?

-Mike