在模块或窗体声明处写 标准模块中这样写: Option Explicit Public cn As New ADODB.Connection '定义数据库的连接 Public rs As New ADODB.Recordset窗体声明这样写:Option Explicit Private cn As New ADODB.Connection '定义数据库的连接 Private rs As New ADODB.Recordset
做成全局变量Option Explicit Public cn As New ADODB.Connection '定义数据库的连接 Public rs As New ADODB.Recordset整个工程一个地方定义就可以了
标准模块中这样写:
Option Explicit
Public cn As New ADODB.Connection '定义数据库的连接
Public rs As New ADODB.Recordset窗体声明这样写:Option Explicit
Private cn As New ADODB.Connection '定义数据库的连接
Private rs As New ADODB.Recordset
Public cn As New ADODB.Connection '定义数据库的连接
Public rs As New ADODB.Recordset整个工程一个地方定义就可以了