Easy - revoke sql delete privlage from specific username and use
UID=username in the ODBC connection string when connecting to the database
instance. Same for OLE-DB.

Noel

"brett simpson" <bsimpson@actrol.com.au> wrote in message
news:3f024fd1$1_1@news.iprimus.com.au...
> How do prevent an ODBC user from deleting data ?
>
> thanks
>
>