Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2005

    Unanswered: Cannot create object

    Dim dbPathName As String
    dbPathName = "p:\db1.mdb"
    Dim strPassword As String
    Dim Acc As Object, db As Object

    Set Acc = CreateObject("access.application")
    Set db = Acc.Application.DBEngine.Workspaces(0).OpenDatabas e(dbPathName, 0, False)
    Acc.OpenCurrentDatabase dbPathName, False

    When I run the above code, it give out the error message:
    Run-time Error '429'
    ActiveX component can't create object.

    Library is DAO 3.6, I already applied it to Reference.

    what's wrong with it?
    Last edited by accessman2; 07-25-06 at 18:03.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts