How to fix runtime error 424

Written by rory parkes
  • Share
  • Tweet
  • Share
  • Email

When your computer displays the messages "Run-time Error '424': Object Required," then there are two common causes. First, the 'Data Access Object' library is not properly referenced, therefore your computer is having difficulty accessing the file. Secondly the 'Data Access Object' files are missing, damaged or improperly registered. The method of fixing an "Error 424" requires editing the registry.

Skill level:


    If The "Data Access Object Library" Is Not Registered

  1. 1

    Open Microsoft Excel 7.0.

  2. 2

    Use the mouse and click on a module sheet.

  3. 3

    Click on the tab at the top of the page marked "Tools," scroll down and click on "References."

  4. 4

    Click on "Microsoft DAO 3.0 Object Library" in the dialogue box under Advanced References. Click on "OK" to confirm and continue to Step 6. If "Microsoft DAO 3.0 Object Library" is not available, continue to step 5.

  5. 5

    Click on the box marked "Browse." Locate the file Dao3032.dll by browsing through, "Program Files," "Common Files," "Microsoft Shared" and finally "Dao." In this folder file Dao3032.dll will be present. Click the file and click "OK" to confirm.

  6. 6

    Click "OK" in the References box to confirm and save your new settings. If this has not corrected "Error 424," continue to Section 2.

    If the "Data Access Object Files" Are Missing, Damaged, Or Unregistered

  1. 1

    Open the start menu and click on the program "Run." Enter "regedit" into the Run open box. Click "OK."

  2. 2

    Click and open the folders in the registry editor in the following order: "HKEY_LOCAL_MACHINE," "Software," "Microsoft," "Windows, " "Current Version, " finally open "SharedDLLs."

  3. 3

    Click on the value "C:\Program Files\Common Files\Microsoft Shared\DAO\dao3032.dll" in the SharedDLLs folder. Excel 97 users click on the value "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL"

  4. 4

    Click "modify" in the Edit Menu to open the "DWORD value dialogue box". Enter "1" into the dialogue box and click OK. Click "Exit" on the registry editor.

  5. 5

    Run the "Microsoft Office Setup program in maintenance mode." When prompted click "Remove All" and again click "Remove All" to shared components. Restart the computer after Setup is completed. Re-Install Microsoft Office using the "Microsoft Setup Disk."

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.