怎样在vb中用ado打开access有密码的数据库? 我先是想试着用ado的测试方式来获得ado打开access有密码的数据库,但始终就测试失败,各位朋友,指点指点呀.谢了。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 dim cn As New ADODB.Connection cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\trade.mdb;Jet OLEDB:Database Password=XXXX;" cn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\proCMMS(\mataformobile.mdb;Persist Security Info=True;Jet OLEDB:Database Password=****" cn.ConnectionString = "DBQ=" & App.Path & "\TelePhone.mdb;DefaultDir=" & _ App.Path & ";Driver={Microsoft Access Driver (*.mdb)};" & _ "DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;" & _ "MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;" & _ "Threads=3;UID=ADMIN;UserCommitSync=Yes;PWD=admind1234;" oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=c:\somepath\mydb.mdb;" & _ "Uid=Admin;" & _ "Pwd=;" 以只读方式打开 localcon1.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\localdb.mdb;" & "Mode=Share Deny Read|Share Deny Write;Persist Security Info=False;Jet OLEDB:Database Password=" & mdbtmp通过odbc Set localcon1 = New ADODB.Connection localcon1.ConnectionString = "DSN=localdb;UID=;PWD=" & mdbtmp & ";" localcon1.ConnectionTimeout = 60 localcon1.Open cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\trade.mdb;Jet OLEDB:Database Password=XXXX cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & app.path & "\web.mdb";Jet OLEDB:Database Password=XXXX 参照MSDN中《Microsoft OLE DB Provider for Microsoft Jet》主题 asp在线提交的信息如何写入mysql数据表? 为什么我的窗体最大化时ScaleHeight值为0呢? 进度条、运行时间问题 ACCESS密码保护后,VB就不能连接了,怎么回事 如何把.gif格式的图标转化成.ico各式的,在线等,急用! 请问如何使用WaitforSingleObject?具体方法。 vb新手 请教高手!!!好急啊!!! Access 数据库转化为Execl,求助! 高分!呵呵~~也不高了。请行家来看看。 ADODC控件连接数据库问题 Inputbox一问。
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\trade.mdb;Jet OLEDB:Database Password=XXXX;"
cn.open
App.Path & ";Driver={Microsoft Access Driver (*.mdb)};" & _
"DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;" & _
"MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;" & _
"Threads=3;UID=ADMIN;UserCommitSync=Yes;PWD=admind1234;"
"Dbq=c:\somepath\mydb.mdb;" & _
"Uid=Admin;" & _
"Pwd=;"
localcon1.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\localdb.mdb;" & "Mode=Share Deny Read|Share Deny Write;Persist Security Info=False;Jet OLEDB:Database Password=" & mdbtmp
通过odbc
Set localcon1 = New ADODB.Connection
localcon1.ConnectionString = "DSN=localdb;UID=;PWD=" & mdbtmp & ";"
localcon1.ConnectionTimeout = 60
localcon1.Open