Can't use OpenDatabase method in Excel VBA???

[Paladyr]

When I try to do the following:

Dim strCnn As String
Dim dbFac As DAO.Database
Dim db As DAO.Database

Dim rst As DAO.Recordset  
 
  Set db = db.OpenDatabase _
  ("C:\Projects\CustomReports\ctx2000.mdb", _
  False, False, "MS Access;PWD=****")
[\code]

It highlights the .OpenDatabase and says member not found.  I have the "Microsoft DAO 3.6 Object Library" reference installed, and still can't do this.  Any ideas?  Am I supposed to be able to do this or do I need a "Developer's License" like the one you get with visual basic?  Thanks!

 

[Paladyr]

Okay, now I am trying it in visual Basic and it is giving me the same message. I have the same references installed. What could be wrong?

 

[Paladyr]

Well, maybe I'm wrong on the VB. I tried to import the forms I created in Excel and that is where this opendatabase method is being used, however the forms don't show up under forms, they are under a folder called designer. I'll try creating a new form in VB and see if it works.