因为数据库是access2000的,而我没有access2000,我用ado的Connection打开数据库,但我要将本数据库的前两个表打开(不知道表名),我应该如何知道表名呢?Dim sbcn As New ADODB.Connection
Dim rds As New ADODB.Recordset
Dim i As Integer
sbcn.ConnectionString = "driver={Microsoft access driver (*.mdb)};dbq=" & _
App.Path & "\test.MDB;pwd="
sbcn.CommandTimeout = 20
sbcn.Open
''''''''
sbcn.Close
Dim rds As New ADODB.Recordset
Dim i As Integer
sbcn.ConnectionString = "driver={Microsoft access driver (*.mdb)};dbq=" & _
App.Path & "\test.MDB;pwd="
sbcn.CommandTimeout = 20
sbcn.Open
''''''''
sbcn.Close
解决方案 »
- MSHTML的图片对象如何保存
- 关于mshflexgrid控件固定列以及有了固定列后我选择某一行如何使整行都高亮显示的问题??急!
- 如何控制Datagrid列值的字符数(高手指教,在线等)
- Text控件问题!!!在线等!!急!
- 如何获得数据库中指定行指定字段下的内容!
- calendar1日历控件问题
- 怎样做出像PhotoShop中打开图片文件时显示一个打开的进度条?
- 判斷一個網址或網頁是否存在能夠訪問有什么方法可以做到
- 统计SQL ,
- 请问怎么不用CommonDialog控件,设置系统的默认打印机。
- 怎样把菜单里面的选项与toolbar 里面的按钮对应
- 前辈们,我怎么觉得拿VB6做程序这么慢啊~~~~~~
Microsoft Activex Data Objects 2.5 Library
Microsoft Ado Ext 2.6 For DDL And Security
'=====================================================
Public mCon As ADODB.Connection
Public mCat As ADOX.CatalogPublic DB_Name As String
Public DB_Title As String
Private Sub Command1_Click()
Dim I As Long
Dim TBL As ADOX.Table
If Not mCon Is Nothing Then Set mCon = Nothing
Set mCon = New ADODB.Connection
mCon.Provider = "Microsoft.Jet.OLEDB.4.0"
mCon.Mode = adModeRead
mCon.CursorLocation = adUseClient
mCon.Properties("Data Source") = "E:\WORKSHAR\CODE.MDB"
mCon.Properties("Jet OLEDB:Database Password") = ""
mCon.Open
Set mCat = New ADOX.Catalog
mCat.ActiveConnection = mCon
For Each TABL In mCat.Tables
Debug.Print TABL.Name
Next
End Sub
你真厉害,你们东莞立晨企资是干什么的,能和你成为朋友吗?
cn1.Open
Set rs = cn1.OpenSchema(adSchemaTables)
lstTable1.Clear
lblStatus1.Caption = "数据源连接成功,正在检索数据表..."
DoEvents
Do Until rs.EOF
If Trim(rs!TABLE_TYPE) = "TABLE" Then lstTable1.AddItem Trim(rs!TABLE_NAME)
rs.MoveNext
Loop
rs.Close
Set rs = Nothing这是将表名取出来放到LISTBOX控件里