I'm trying to set a recordset using an SQL string and the OpenRecordset function.
Set rstTemp = dbs.OpenRecordset(strSQL, dbOpenSnapshot)
I use similar code in another database, and it works fine there. It doesn't matter what query I put into strSQL, it won't run. I can run the query in the database, but it doesn't work in the VBA code. Any ideas? Thanks.