access(必须把数据库所在的文件夹共享): '引用ADO(Microsoft ActiveX Data Objects 2.X Library) Private Sub Command1_Click() On Error GoTo err Dim cn As New ADODB.Connection, rs As New ADODB.Recordset '有密码的连接方式 'cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\服务器名\共享目录名\数据库名.mdb;Jet OLEDB:DataBase password=12345;" '无密码的连接方式 cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\服务器名\共享目录名\数据库名.mdb;Persist Security Info=False" cn.Open rs.CursorLocation = adUseClient '设置客户端游标 rs.Open "select * from 表1", cn, 3, 2 Set DataGrid1.DataSource = rs Exit Sub err: MsgBox err.Description End Sub
对SQL Server数据库 '引用ADO(Microsoft ActiveX Data Objects 2.X Library) Private Sub Command1_Click() On Error GoTo err Dim cn As New ADODB.Connection, rs As New ADODB.Recordset '有密码的连接: 'cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=数据库名;Data Source=服务器别名" '无密码的连接: cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=数据库名;Data Source=服务器别名" cn.Open rs.CursorLocation = adUseClient '设置客户端游标 rs.Open "select * from 表1", cn, 3, 2 Set DataGrid1.DataSource = rs Exit Sub err: MsgBox err.Description End Sub
'引用ADO(Microsoft ActiveX Data Objects 2.X Library)
Private Sub Command1_Click()
On Error GoTo err
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
'有密码的连接方式
'cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\服务器名\共享目录名\数据库名.mdb;Jet OLEDB:DataBase password=12345;"
'无密码的连接方式
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\服务器名\共享目录名\数据库名.mdb;Persist Security Info=False"
cn.Open
rs.CursorLocation = adUseClient '设置客户端游标
rs.Open "select * from 表1", cn, 3, 2
Set DataGrid1.DataSource = rs
Exit Sub
err:
MsgBox err.Description
End Sub
'引用ADO(Microsoft ActiveX Data Objects 2.X Library)
Private Sub Command1_Click()
On Error GoTo err
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
'有密码的连接:
'cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=数据库名;Data Source=服务器别名"
'无密码的连接:
cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=数据库名;Data Source=服务器别名"
cn.Open
rs.CursorLocation = adUseClient '设置客户端游标
rs.Open "select * from 表1", cn, 3, 2
Set DataGrid1.DataSource = rs
Exit Sub
err:
MsgBox err.Description
End Sub
“基于文件的数据库访问很容易造成数据库损坏”,尤其在初期设计时一定要慎重
前车之鉴啊
还有建议C/S结构不要使用ACCESS数据库,使用删除记录操作的时候很容易破坏数据库