R
remmons
I have a split application. BE is SQL Server 2008 and FE is Access 2007.
Tables are linked via ODBC.
I am using windows authentication method. I have defined roles with
different permission levels for each table and put the users under the
specified role.
Whenever an insert, update, or delete operation fails, native SQL server
message appears in microsoft access. I would like to trap the error number
and customize the error message so that it looks more user friendly. Any
suggestions?
Tables are linked via ODBC.
I am using windows authentication method. I have defined roles with
different permission levels for each table and put the users under the
specified role.
Whenever an insert, update, or delete operation fails, native SQL server
message appears in microsoft access. I would like to trap the error number
and customize the error message so that it looks more user friendly. Any
suggestions?