Testing access database

[shipu]

Hi,

When I access the DB, it only asks for password. So I added the password. I get error: could not find installable ISAM.

Please advise.

Code:

Set oAccess= CreateObject("ADODB.Connection")
oAccess.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=H:\qtp\test.accdb;pwd=df"
If oAccess.State = 1 Then
     Msgbox "Pass"&vbcrlf&"Database Connection"&vbcrlf&"Database Connection is Open"
Else
    Msgbox "Fail" &vbcrlf&"Database Connection" &vbcrlf&"Database Connection is not Open"
End If