VB Forum / Database Access / October 2005

Hi

I've tried everything I can think of and nothing seems to work.
If I don't have a password on the database, everything works fine.
If I put a password on it,
I get -2147467259(80004005) could not find installable ISAM.

I'm running
Windows XP Pro Ver 5.1.2600(sp2) build 2600
Visual Basic 6.0 Pro (sp6)
Access 2000 ver 9.0.4402 sr-1

1.  I downloaded and installed sp6 for Visual Studio
2.  I found and registered msrd2x40.dll and msrd3x40.dll

Below is a simplified version of what fails for me.
Any help is greatly appreciated.

Thanks
Dennis

Dim WithEvents cn1 As Connection
Dim rs1 As ADODB.Recordset

Private Sub Command1_Click()

   GProvider = "Microsoft.Jet.OLEDB.4.0"
   GConnectionString = "C:\VBISAM\ABC.mdb Password=pleasehelp"
   'GConnectionString = "C:\VBISAM\ABC.mdb"

   Set cn1 = New Connection
   cn1.Provider = GProvider
   cn1.ConnectionString = GConnectionString
   cn1.Open
   cn1.CursorLocation = adUseClient

   Set rs1 = New Recordset
   rs1.Open "Select * from Owner order by [FULL NAME]", _
                  cn1, adOpenDynamic
                 
   cn1.Close
   Set rs1 = Nothing
     
End Sub