How to Fix Runtime Error 424

If The 'Data Access Object Library' Is Not Registered
1. Open Microsoft Excel 7.0.
2. Use the mouse and click on a module sheet.
3. Click on the tab at the top of the page marked 'Tools,' scroll down and click on 'References.'
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. 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. 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
7. Open the start menu and click on the program 'Run.' Enter 'regedit' into the Run open box. Click 'OK.'
8. Click and open the folders in the registry editor in the following order: 'HKEY_LOCAL_MACHINE,' 'Software,' 'Microsoft,' 'Windows, ' 'Current Version, ' finally open 'SharedDLLs.'
9. Click on the 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'
10. Click 'modify' in the Edit Menu to open the 'DWORD value dialog box'. Enter '1' into the dialog box and click OK. Click 'Exit' on the registry editor.
11. 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.'