In addition to the other posts, permit me to point that one important piece is missing from your post: what error do they get?
And, for that matter, do they insert directly or through a strored procedure?
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]