看看这个,如果不行,自己做一个吧Option Explicit'引用Microsoft OLE DB Service Component 1.0 Type Libaray '然后类似这样Private Sub Command1_Click() Dim oCnn As Connection Dim oDataLink As New DataLinksoDataLink.hWnd = Me.hWnd Set oCnn = oDataLink.PromptNew() Debug.Print oCnn.ConnectionStringCall oDataLink.PromptEdit(oCnn) Debug.Print oCnn.ConnectionString End Sub
连接超时会产生错误代码
'然后类似这样Private Sub Command1_Click()
Dim oCnn As Connection
Dim oDataLink As New DataLinksoDataLink.hWnd = Me.hWnd
Set oCnn = oDataLink.PromptNew()
Debug.Print oCnn.ConnectionStringCall oDataLink.PromptEdit(oCnn)
Debug.Print oCnn.ConnectionString
End Sub