error

[muddasirmunir]

it is the first time i use password with access and get and error
i am using adodc to connect to access by clicking build and then
Microsoft jet 4 ole db now when i uncheck the blank password tick and put
my password it give me the following error (see pictures)
how to solve this.


Note: my access database is closed and not using by any other application

[jamesd0142]

it is the first time i use password with access and get and error
i am using adodc to connect to access by clicking build and then
Microsoft jet 4 ole db now when i uncheck the blank password tick and put
my password it give me the following error (see pictures)
how to solve this.


Note: my access database is closed and not using by any other application

either close the access file which you have open soemwhere..

or its been opend in vb and not closed.

use code like

con.close before you open the connection in your code

example:

Con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\reminder.mdb")
        Con.Close()
...rest_of_code
con.open()
...fill dataset etc