Creating a DAO Recordset in Visual Studio 2005 RRS feed

  • Question

  • I have been trying to create a DAO recordset in Visual Studio 2005 Professional and populate it using an SQL query. The query goes like this:

    Dim rsSave As DAO.Recordset

    rsSave = Books.OpenRecordset("Select * From Business",dbopendynaset ,dbdenywrite , )

    ('Books' is a global variable denoting a DAO Database)

    When execution reaches this line of code an error results ("Object reference not set to an instance of an object")

    I have added a reference to Microsoft Jet in my project.

    Any tips?

    Thursday, September 4, 2008 10:14 PM