请问如何在模块里定义一个 adodc.connection 对象

Question

谢谢!

Answer 1

首先，应该是定义一个ADO.Connection对象确保工程中已经引用了ADO对象
Project/References/Microsoft ActiveX Data Object 2.0 Library
                                                 2.1
                                                 2.2
                                                 2.5
                                                 2.6
                                                 2.7
工程/引用/Microsoft ActiveX Data Object 2.0 Library
                                                 2.1
                                                 2.2
                                                 2.5
                                                 2.6
                                                 2.7
或确保已经在工程中放置了ADODC控件然后就可以在代码编辑器中这样声明ADO对象了
Dim mcnnTransaction As ADODB.Connection

Answer 2

dim a
set a=createobject("adodb.connection")
前提是你的系统里面要有ado，这点我想也不用我再解释了吧？

Answer 3

dim a as adodb.connection
set a=new adodb.connection
你要先引用系统的ado才行.