I would like to connect to an MS Access Database 2007 (Office 2007) and open the database and execute a query. I have the following code in Excel but I'm not able to get the database open and/or query to execute. Can someone let me know what I'm doing incorrectly.Get object error in Set MyRecordset.
Thank you for guidance.
Luis
+++++++++++++++++++++++++++++++++++++++++++++++++++
Dim MyDatabase As DAO.Database
Dim MyQueryDef As DAO.QueryDef
Dim MyRecordset As DAO.Recordset
Set MyDatabase = DBEngine.OpenDatabase(DbName)
Set MyQueryDef = MyDatabase.QueryDefs("qryInfRequirementsMetrics")
Set MyRecordset = MyQueryDef.OpenRecordset
+++++++++++++++++++++++++++++++++++++++++++++++++++++
Thank you for guidance.
Luis
+++++++++++++++++++++++++++++++++++++++++++++++++++
Dim MyDatabase As DAO.Database
Dim MyQueryDef As DAO.QueryDef
Dim MyRecordset As DAO.Recordset
Set MyDatabase = DBEngine.OpenDatabase(DbName)
Set MyQueryDef = MyDatabase.QueryDefs("qryInfRequirementsMetrics")
Set MyRecordset = MyQueryDef.OpenRecordset
+++++++++++++++++++++++++++++++++++++++++++++++++++++