Hi all,

I have decided to attach a password to my access database, which obviously requires a connection string adjustment. However I have adjusted it as follows:

  Const pWord As String = "henry"

  strCn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\despatcher97.mdb; & _ Jet OLEDB:Database Password=" & pWord & ";"""

  Dim strSQL As String
  strSQL = "SELECT * FROM Users ORDER BY Name"

  Dim rst As New ADODB.Recordset
  rst.Open strSQL, strCn

But I am receiving this error.

Run-time error '-2147467259(80004005)':
Could not find installable ISAM

I have tried hunting around for MDAC driver updates etc. and I have installed them, but I still have the same problem.

Any suggestions would be greatly received.

Many thanks,

Paul

Try the following link for connection strings

http://www.connectionstrings.com/index.asp



It is not how much we do,
but how much love we put in the doing.

-Mother Theresa