Connection error to microsoft access 2003 with password

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • calvinkwoo3000
    New Member
    • Apr 2008
    • 4

    Connection error to microsoft access 2003 with password

    My Window application run property withour link to mdb without password.
    Once i set security password to mdb file, the error belor come out when i click detail.

    Not a valid password. and detail as below

    the string to connect to mdb is conn = new OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=|DataDir ectory|\\mms.md b;Jet OLEDB:Database Password=passwo rd;");

    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.Data.Ole Db.OleDbExcepti on: Not a valid password.
    at System.Data.Ole Db.OleDbConnect ionInternal..ct or(OleDbConnect ionString constr, OleDbConnection connection)
    at System.Data.Ole Db.OleDbConnect ionFactory.Crea teConnection(Db ConnectionOptio ns options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection owningObject)
    at System.Data.Pro viderBase.DbCon nectionFactory. CreateNonPooled Connection(DbCo nnection owningConnectio n, DbConnectionPoo lGroup poolGroup)
    at System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection owningConnectio n)
    at System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection outerConnection , DbConnectionFac tory connectionFacto ry)
    at System.Data.Ole Db.OleDbConnect ion.Open()
    at System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    at System.Data.Com mon.DbDataAdapt er.Fill(DataTab le[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
    at System.Data.Com mon.DbDataAdapt er.Fill(DataTab le dataTable)
    at Mortgage_manage ment_system.ban krateDataSetTab leAdapters.Bank Rate2TableAdapt er.FillBankLoan Rates(BankRate2 DataTable dataTable, String hse, Double per) in C:\Inetpub\wwwr oot\Mortgage management system\Mortgage management system\bankrate DataSet.Designe r.cs:line 1276
    at Mortgage_manage ment_system.Ban kLoanRatesForm. .ctor(String houseType, Double percentage, String t) in C:\Inetpub\wwwr oot\Mortgage management system\Mortgage management system\BankLoan RatesForm.cs:li ne 23
    at Mortgage_manage ment_system.pri vatePropertyFor m.hdb80Btn_Clic k(Object sender, EventArgs e) in C:\Inetpub\wwwr oot\Mortgage management system\Mortgage management system\PrivateP ropertyForm.cs: line 4943
    at System.Windows. Forms.Control.O nClick(EventArg s e)
    at System.Windows. Forms.Button.On Click(EventArgs e)
    at System.Windows. Forms.Button.On MouseUp(MouseEv entArgs mevent)
    at System.Windows. Forms.Control.W mMouseUp(Messag e& m, MouseButtons button, Int32 clicks)
    at System.Windows. Forms.Control.W ndProc(Message& m)
    at System.Windows. Forms.ButtonBas e.WndProc(Messa ge& m)
    at System.Windows. Forms.Button.Wn dProc(Message& m)
    at System.Windows. Forms.Control.C ontrolNativeWin dow.OnMessage(M essage& m)
    at System.Windows. Forms.Control.C ontrolNativeWin dow.WndProc(Mes sage& m)
    at System.Windows. Forms.NativeWin dow.Callback(In tPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


    ************** Loaded Assemblies **************
    mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
    CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

    and some more ............... ...............

    last


    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config ) must have the
    jitDebugging value set in the system.windows. forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    <configuratio n>
    <system.windows .forms jitDebugging="t rue" />
    </configuration>
Working...