Chris,

Thanks for the reply. I have also thought of going with the stored procedure route. I am both the DBA and one of the developers, so I guess I could argue with myself about how much trouble the programming is with stored procedures 😀

What I am really trying to protect against is what I call rogue systems (Some user connects using an access database and starts throwing together a "custom" data entry program) from cropping up and messing with the data. The thing that spooked me is the windows authentication and its double edged automatic connection to the database.

Perhaps I am being paranoid.

John