When I enter data in through an Access front end, I also get an error. I do not get the error without the insert function in the trigger. The fact that I get an error in the SEM indicates that the error in Access is not an Access error, but coming from SQL. Sergey does not seem to get the error in his test, but I get it on two different servers.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.