Quick method to resolve the runtime error 424: object required
March 13th, 2010
A runtime error can be caused by various different issues such as some conflict with another running program or some software issue and so on. It can also be due to virus or can be a memory issue as well. When you run a Visual Basic for Applications macro that uses Data Access Object, you may receive the following error message: runtime error 424 object required.
Open the file and press ALT+F11 to open the Visual Basic Editor. In the Visual Basic Editor, go to Tools > References > Available References and click “Microsoft DAO 3.5 Object Library,” and then click OK. If “Microsoft DAO 3.5 Object Library” is not listed in the box under Available References, click Browse and find the Dao350.dll file. This file is located in the following folder: Program Files\Common Files\Microsoft Shared\Dao.
Entry Filed under: Computers and Technology