Is Snapshot better than Open Dynaset
Posted on 2008-10-01
I have an Access front end and a SQL backend. I have a lot a mix and match code trying to transition from VBA to SQL. Is one of these statements better/faster/more efficient than the other if my backend is SQL?
Set rs2 = CurrentDb.OpenRecordset("tblMTTestRooms", DB_OPEN_DYNASET)
Set rs2 = CurrentDb.OpenRecordset("SELECT * FROM tblMTTestRooms", DB_OPEN_SNAPSHOT)