Returning SQL Server error messages

S

s

I have an Accesss 2002 adp file that connects to SQL Server 2000. We are
now using Access 2003 and I have found that Access does not appear to be
catching errors raised on the server. I used to execute "RunCommand
acCmdSaveRecord" and if there were any errors on the server I would capture
Err number 5000. Under Access 2003 the server side errors do not get passed
to the client.

Any ideas why this is no longer working? Tx.
 
Top