Isam error

[mdeokute]

I am gettig "could not find installable isam" while connecting to access 2007 databse
the code that i wrote is:

Public Sub MyConnection()
constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Contact_management\Contact_DB.accdb;Jet oledb:database password=abcd"
con = New OleDbConnection(constr)
If con.State = ConnectionState.Open Then
con.Close()
End If
con.Open()
End Sub

i installed office 2007 via network.
when i remove database password , m able to connect to database and when i set it i m unable to.

what would be a problem?

[pocohontus]

you hv to provide user id along with d pw ....better put in a access database
or remove id n pw completely n use "persist security info=false"

[uv4u]

'use this connection string
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\MAINDB.mdb;Jet OLEDB:Database Password=test"

[uv4u]

connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\MAINDB.mdb;Jet OLEDB : Database Password=test"

[mdeokute]

you hv to provide user id along with d pw ....better put in a access database
or remove id n pw completely n use "persist security info=false"

is it user id and passwordg in that we use to log in?
if i use persist secuity info=false will i be able to protect database from opening it?
thanx

[mali.sandhya2]

Why this error will occurred?

[mdeokute]

you hv to provide user id along with d pw ....better put in a access database
or remove id n pw completely n use "persist security info=false"

thanx it worked!

[uv4u]

open configuration file then u will come to know

[mdeokute]

Why this error will occurred?

we use it because we are using password protected database .
we make it to false so that windows will not remember the password.

[pocohontus]

thanx it worked!

welcome