Results 1 to 3 of 3

Thread: Please help me with this Run-Time Error!

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2000
    Posts
    7

    Exclamation

    I just finished packaging my new VB6.0 program that works just fine on several machines that have VB6.0 installed on them...

    When I try to install it on a machine that doesn't have VB6.0 installed, When I run the program I get a Run-time error '91' (Object Variable or With block variable is not set). This occurs directly when the DAO connection to the Access2000 database is trying to perform...

    I thought it might be that the dll wasn't registring properly, so I tried running regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.dll" and still had no luck.

    Here is some example code:
    'Open link to Access database
    DBpathBudgetInfo = "C:\MLRS\mlrsdata.mdb"
    Set daoDB36BudgetInfo = DBEngine(0).OpenDatabase(DBpathBudgetInfo)
    Set rsBudgetInfo = daoDB36BudgetInfo.OpenRecordset("BudgetInfoTable")
    Set DataBudgetInfoTable.Recordset = rsBudgetInfo

    'Add all DateReqmtDue values from Requirement Table to Combo Box List
    DataBudgetInfoTable.Refresh
    If DataBudgetInfoTable.Recordset.EOF = False Then
    DataBudgetInfoTable.Recordset.MoveFirst

    Your help will be GREATLY APPRECIATED!!! Thanks for your reply

  2. #2
    Addicted Member smh's Avatar
    Join Date
    Oct 2000
    Location
    South Dakota, USA
    Posts
    249

    dll

    Try adding DAO350.dll to your package. It's located in the same folder as the DAO360.dll. This fixed my problem. Don't know why though...

    smh
    Normal is boring...

    smh

  3. #3

    Thread Starter
    New Member
    Join Date
    Oct 2000
    Posts
    7
    Thanks for the help SMH ... it took care of my problem as well!

Posting Permissions

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



Click Here to Expand Forum to Full Width