I'd like to open a recordset 'within' another transaction (i.e., whilst a transaction is active), but I do not
want this recordset to be subject to the transaction locking. Is this possible? The aCondition is actually error handling, and I want errors to be logged if they are not handled correctly. It can't be determined whether a .Rollback would be appropriate until the error is added to the rLogging table
Dim dbs as DAO.Database
Dim rLogging As DAO.Recordset
Dim rFeeder As DAO.Recordset
Dim rTable As DAO.Recordset
Dim wks As DAO.Workspace
fOpenRecordset dbs, rFeeder, sSQL, dbOpenSnapshot
fOpenRecordset dbs, rTable, sSODTableName, , dbAppendOnly
Set wks = DBEngine.Workspaces(0)
Do While Not rFeeder.EOF
If aCondition Then
'open recordset for append only, not subject to transaction?
Set rFeeder = Nothing
Set rTable = Nothing
Is this possible?