Question

VB怎样和ACCESS数据库连接 Adocd1

VB怎样和ACCESS数据库连接 Adocd1

Answer 1

Set conn = New ADODB.Connection
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Administrator\桌面\工程\vb与数据库的链接\代码型连接\通讯录管理.mdb;"
conn.Open connstr

Set rs = New ADODB.Recordset
Dim strsql As String
strsql = "select * from 成绩表 "
rs.Open strsql, conn, adOpenKeyset, adLockOptimistic
rs.MoveFirst

Answer 2

可以通过控件adodc右键属性，设置属性来完成链接