vc + ado 打不开带密码的access 2003解决办法
vc + ado 打不开带密码的access 2003
论坛上的相似的答案用了都不行.我的access加密码时,access 要求用独占方式打开.
不加密码时是能打开的.
try
{
//打开本地Access库
m_pConnection-> Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\PROJECT\vc project\sdau\sdu1.mdb; ", " ", " ",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox( "数据库连接失败,确认数据库sdau1.mdb是否在当前路径下! ");
return FALSE;
}
可是加了密码就提示打不开
try
{
//打开本地Access库
m_pConnection-> Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\PROJECT\vc project\sdu\sdu1.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=sdu ", " ", " ",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox( "数据库连接失败,确认数据库sdau1.mdb是否在当前路径下! ");
return FALSE;
}
高手请帮忙.在线等
------解决方案--------------------
m_pConnection-> Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\PROJECT\\vc project\\sdu\\sdu1.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=sdu ", " ", " ",adModeUnknown);
------解决方案--------------------
是不是应该把密码写入连接字符串的password=后面啊
------解决方案--------------------
m_pConnection-> Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\PROJECT\\vc project\\sdu\\sdu1.mdb;Jet OLEDB:Database Password= 'sdu ';User ID=admin;Password=; ", " ", " ",adModeUnknown);
------解决方案--------------------
_pConnection-> Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\PROJECT\\vc project\\sdu\\sdu1.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=sdu ", " ", " ",adModeUnknown);
论坛上的相似的答案用了都不行.我的access加密码时,access 要求用独占方式打开.
不加密码时是能打开的.
try
{
//打开本地Access库
m_pConnection-> Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\PROJECT\vc project\sdau\sdu1.mdb; ", " ", " ",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox( "数据库连接失败,确认数据库sdau1.mdb是否在当前路径下! ");
return FALSE;
}
可是加了密码就提示打不开
try
{
//打开本地Access库
m_pConnection-> Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\PROJECT\vc project\sdu\sdu1.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=sdu ", " ", " ",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox( "数据库连接失败,确认数据库sdau1.mdb是否在当前路径下! ");
return FALSE;
}
高手请帮忙.在线等
------解决方案--------------------
m_pConnection-> Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\PROJECT\\vc project\\sdu\\sdu1.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=sdu ", " ", " ",adModeUnknown);
------解决方案--------------------
是不是应该把密码写入连接字符串的password=后面啊
------解决方案--------------------
m_pConnection-> Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\PROJECT\\vc project\\sdu\\sdu1.mdb;Jet OLEDB:Database Password= 'sdu ';User ID=admin;Password=; ", " ", " ",adModeUnknown);
------解决方案--------------------
_pConnection-> Open( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\PROJECT\\vc project\\sdu\\sdu1.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=sdu ", " ", " ",adModeUnknown);