用这个连接串试试.
Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=123;Data Source="...\temp.MDB";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider="Microsoft.Jet.OLEDB.4.0";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False
注意,第一个password填你的密码,其他的password请不要填,空在那里
Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=123;Data Source="...\temp.MDB";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider="Microsoft.Jet.OLEDB.4.0";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False
注意,第一个password填你的密码,其他的password请不要填,空在那里
解决方案 »
- 请教一个问题
- 把textbox变成"控制台"~
- 玩过的朋友们进来帮帮我
- 如何保证某列数据不重复,c# winform开发,与数据库无关 ...
- 请问怎么在winform里显示网页图片呀?
- 如何把11001001100110110010011001101100100110011011001001100110(二进制)转化为字符串啊(MM-急!!!)
- 用c#编程实现对复数操作符的重载
- 求助:有一个textBox1和一个button1,比如在textBox1 中输入"OK",然后又把"OK"改为"Cancel"我想按button1的时候,"Cancel"会还原为"OK",就是
- <authentication mode="Windows" />
- C# 一个封装问题
- 这个SQL该怎么写?
- 求助!
但是连接总是出错,说什么组信息丢失,或者被其他程序以独占的方式打开
this.connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+_db_Dir+";Jet OLEDB:Database Password=1234;User ID=admin;" ;
Standard Security:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;Uid=Admin;Pwd=asdasd;"
Workgroup:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;SystemDB=\somepath\mydb.mdw;","admin", ""
OLEDB, OleDbConnection (.NET) 方式
Standard security:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=asdasd;"
Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;","admin", ""
With password:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;","admin", ""
public void Init()
{
try
{
if(_DBConn==null)
{
string MdbConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=lhkj;Data Source="+Application.StartupPath+"\\data\\Print.mdb;Persist Security Info=True";
_DBConn = new OleDbConnection();
_DBConn.ConnectionString = MdbConnectionString;
_DBConn.Open();
} }
catch(System.Exception error)
{
MessageBox.Show(error.Message);
}
}
奇怪了,为虾米这位仁兄的也能用呢?我以前试过不行的啊
Persist Security Info=False