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?

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"

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

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

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

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!

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.

This article has been dead for over six months. Start a new discussion instead.