1,216
社区成员
发帖
与我相关
我的任务
分享
Private Sub Command1_Click()
Dim adoconn As ADODB.Connection
Dim adors As ADODB.Recordset
Dim sconnectionstring As String
Set adoconn = New ADODB.Connection
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Microsoft Visual Studio\VB98\BIBLIO.MDB"
adoconn.Open sconnectionstring
Set adors = adoconn.OpenSchema(adSchemaPrimaryKeys)
Do Until adors.EOF
Debug.Print "数据表名:;"; adors!table_name;
Debug.Print Tab(30); "主键:"; adors!column_name
adors.MoveNext
Loop
adors.Close
adoconn.Close
End Sub