Which Access 2007 References are needed when using DAO?
Posted on 2012-09-18
Within an Access 2007 database, I am receiving 'Operation must use an Updateable query' message in code where there is not an update query. The code does contain db.Execute "INSERT INTO ...." and I set db using the following statements:
Dim db As DAO.Database
Dim rst As DAO.Recordset
set db = CurrentDb()
Set rst = db.OpenRecordset(strSQL, dbOpenDynaset)
I am wondering if there is a problem with the references that are set. The database generates emails and imports data from Excel and Word.
Which references are needed and in what order should they occur?
I currently have the following references selected (and am thinking that the reference to Access database engine Object Library should not be selected):
Visual Basic For Applications
Microsoft Access 12.0 Object Library
Microsoft Office 12.0 Access database engine Object Library
Microsoft Visual Basic for Applications Extensibility 5.3
Microsoft Office 12.0 Object Library
Microsoft Excel 12.0 Object Library
Microsoft Word 12.0 Object Library