关于vb与access连接的最最基础的问题！！

[haoranily]

老师让我们做一个信息管理系统！用vb做界面access做数据库！然后能够实现简单的功能就可以了 ，但是vb与access怎么连接我是一窍不通，请各位给我解答一下我想应该是很简单的！我做了一个下拉框就是希望在我点击的时候能出现数据库中的相关内容！谢谢啊

[colorslife]

找本基础的书看看呢

引用:Microsift ActiveX Object 2.x Library

然后，
Dim Cnn as new Connection
Dim Rs as new Recordset
Cnn.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\db1.mdb;Persist Security Info=False"

Cnn.Open

rs.open "表名"，cnn

你自己参照着写吧

[xiangfly]

Dim Cnn as new Connection
Dim Rs as new Recordset
Cnn.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\db1.mdb;Persist Security Info=False"

Cnn.Open

rs.open "select * from TableName", Cnn, adOpenKeyset, adLockOptimistic

[believe209]

Dim Cnn as new ADODB.Connection
Dim Rs as new ADODB.Recordset
Cnn.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\My Documents\db1.mdb;Persist Security Info=False"

Cnn.Open

rs.open "select * from TableName", Cnn, adOpenKeyset, adLockOptimistic

具体请参考Connection.open
Recordset.open 这两个方法,查一下帮助!