sql server odbc: i have the odbc connection connected to our SQL databasse via sql user
account through MS access Frontend and having problem controling the delete
function of the account.

In SQL i am only allow the account to read, insert,update and denied delete
on the database and tables. However, the account still be able delete the
records.

Sang,

I don't know if this applies in your case, since I don't understand enough
about your setup.

However, MS Access if running under a proxy account (a SQL login embedded in
the program) can create other connections that do not use this account. Once
place this is described is: http://support.microsoft.com/kb/308312

It makes the comments on subforms: ...Access does not always use the same
connection to retrieve the data source of a subform. Access frequently (but
not always) creates a new connection to SQL Server ... a permissions error
may be generated ...

If this is the source of your problem, it could be that the persons running
your MS Access application have rights to delete data that the SQL User
account for your application does not have. If that is the case, then you
need to revoke delete rights to those people as well.

FWIW,
RLF

[quoted text, click to view]