Viewing 5 posts - 1 through 5 (of 5 total)
Are you prefixing the procedure name with dbo when you make the call:
.commandtext = "dbo.prMyProcedure"
How are you calling the procedure, using a command object or using the open method of...
August 21, 2006 at 8:26 am
I did some more research on trapping error messages in ADO. First, by Default RAISERROR assigns the number 50000 to user defined error messages that are not in the SysMessages...
August 9, 2006 at 10:34 am
I still don't understand why you need to do this using errors. I appears that you want to check for certain conditions throughout your stored procedure, and send a message...
August 9, 2006 at 9:16 am
I just reread your post and realize I misunderstood what you were trying to accomplish. I have never used DAO to connect to SQL server from an Access project. I...
August 8, 2006 at 3:44 pm
The only time SQL server reports an error back to Access is when the severity level is 19 or higher and the procedure is terminated. It appears that in your...
August 8, 2006 at 2:54 pm
Viewing 5 posts - 1 through 5 (of 5 total)