如何在MS Access Form数据库中管理错误代码SQL? [英] How can I manage error code SQL in MS access form database?

问题描述

我想以访问方式管理SQL Server错误代码 来自SQL Server的示例重复错误

I want manage SQL server error code in access form sample duplicate error from SQL server

推荐答案

您可能必须按照它显示了此示例代码:

Sub DescriptionX() 

   Dim dbsTest As Database 

   On Error GoTo ErrorHandler 

   ' Intentionally trigger an error. 
   Set dbsTest = OpenDatabase("NoDatabase") 

   Exit Sub 

ErrorHandler: 
   Dim strError As String 
   Dim errLoop As Error 

   ' Enumerate Errors collection and display properties of  
   ' each Error object. 
   For Each errLoop In Errors 
      With errLoop 
         strError = _ 
            "Error #" & .Number & vbCr 
         strError = strError & _ 
            "  " & .Description & vbCr 
         strError = strError & _ 
            "  (Source: " & .Source & ")" & vbCr 
         strError = strError & _ 
            "Press F1 to see topic " & .HelpContext & vbCr 
         strError = strError & _ 
            "  in the file " & .HelpFile & "." 
      End With 
      MsgBox strError 
   Next 

   Resume Next 

End Sub 

这篇关于如何在MS Access Form数据库中管理错误代码SQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！