Dim mycon As ADODB.Connection
Set mycon = New ADODB.Connection
mycon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DataPath & "db1.mdb"
mycon.Open //链接mdb数据库
select 字段名1,字段名2 from 【access表名】 where 【条件】 //从表中查询字段
Dim mycon As ADODB.Connection
Set mycon = New ADODB.Connection
mycon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DataPath & "db1.mdb"
mycon.Open
mycon.Execute "delete from newsclass where classid=" & delnewsclassid
Set mycon = Nothing
用access库也是要用SQL语句的,这是一个删除的例子
很簡單,你在你的工程文件的地方新增一個.udl的文件,然後選一個連接的數據源,在到程式中設定一下:
--------modul1-------
sub main
With anCN
.ConnectionString = "FILE NAME=" & App.Path & "\ChingFeng.udl"
.CursorLocation = adUseClient
.Open
End With
frmMain.show '------主窗體
end sub
----------------modul2------------------
Public anCN As New ADODB.Connection