与Access相关的问题 [英] Problem in connection with Access
问题描述
我使用下面提到的代码将vb6与ms access连接起来
但是当我运行项目时,它会显示编译错误(未定义用户定义类型)并突出显示此行(Conn As ADODB.Connection)
请解决这个问题
全局连接为ADODB.Connection
全局rs As ADODB.Recordset
子Access_Connector()
设置Conn = New ADODB.Connection
Conn.Provider ="microsoft.jet.oledb.4.0"
Conn.CursorLocation = adUseClient
Conn.Open App.Path和"\ SIS.mdb"
结束Sub
I use the below mentioned code for Connecting vb6 with ms access
but when i run the project it displays the Compile error which is( User Defined type not defined) and highlight this line ( Conn As ADODB.Connection )
Pls solve this problem
Global Conn As ADODB.Connection
Global rs As ADODB.Recordset
Sub Access_Connector()
Set Conn = New ADODB.Connection
Conn.Provider = "microsoft.jet.oledb.4.0"
Conn.CursorLocation = adUseClient
Conn.Open App.Path & "\SIS.mdb"
End Sub
推荐答案
您需要添加ADODB的引用.请参阅本教程,清楚地解释所有内容.
Visual Basic 6& ADO教程 [^ ]
You need to add the reference for ADODB. See this tutorial, explained all things clearly.
Visual Basic 6 & ADO Tutorial[^]
这篇关于与Access相关的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!