adodc控件用程序访问数据库
用VB6的时候创建了个adodc控件，我想用程序实现控件连接数据库，而不是从控件属性里设置连接，但每次启动都提示验证失败啊，请问该怎么设置，怎么来实现程序操作呢，我要访问的数据库很多，要随时更换的，
[解决办法]
呵呵，这个问题我来解答吧
===============================================================================================
dim sqlstring as string '定义变量
sqlstring = "select [NO] as 學號,[NAME] as 姓名,[GENDER] as 性別,[CELLPHONE] as 手機號碼,[QQ] as QQ號碼,[TELEPHONE] as 傢庭電話,[ADDRESS] as 籍貫 from 同学录 order by [NO]"
Adodc1.RecordSource = sqlstring
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\同學錄數據.mdb;Persist Security Info=False"
Adodc1.CommandType = adCmdText
Adodc1.Refresh
Adodc1.Recordset.MoveFirst
===============================================================================================
这是我之前作的，可以导入，如果不能，可能是一些比较比较具体的问题，如果需要解答，请说明白一点
