I am trying to load a ADO recordset from within access 2007 and just cannot get it to work. I recieve an error "Error in Loading DLL Is this a missing reference problem?
Dim rs As New ADODB.Recordset
Dim StrSQL As String
StrSQL = "SELECT * FROM [TableName];"
rs.Open StrSQL, CurrentProject.Connection 'or .AccessConnection same error
Can someone please provide a sample VBA code to use ADO in Access 2007. I normally use DAO except I would like to take advantage of the recordset .Save and .Load features of ADO for one application.
Thanks in advance for any assistance you can provide.