Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Creating a DAO Recordset in Visual Studio 2005 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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?

    Chandran
    Thursday, September 4, 2008 10:14 PM

Answers