ACC: Memo and OLE Fields in a Snapshot Are Not Static

MORE INFORMATION

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0).
2. Create the following new function in a module:

        Public Function TestSnapshot()
            Dim SS As Recordset
            Dim DS As Recordset
            Dim DB As Database
   
            Set DB = CurrentDb()
   
            ' Create a snapshot and recordset of the Categories table.
            Set SS = DB.OpenRecordset("Categories", dbOpenSnapshot)
            Set DS = DB.OpenRecordset("Categories", dbOpenDynaset)
   
            ' Move to the first record.
            SS.MoveFirst
            DS.MoveFirst
   
            ' Print the contents of the CategoryName and Description
            ' .. fields from both record sets. CategoryName is a
            ' .. Text field and Description is a Memo field.
            Debug.Print
            Debug.Print "Snapshot:"
            Debug.Print "   CategoryName: " & SS![CategoryName]
   
            ' NOTE: In versions 1.x and 2.0, type a space in the Category
            ' field name.
   
            Debug.Print "   Description: " & SS![Description]
            Debug.Print "Dynaset:"
            Debug.Print "   CategoryName: " & DS![CategoryName]
            Debug.Print "   Description: " & DS![Description]
   
            ' Alter the Description and CategoryName fields using
            ' ... the dynaset.
            DS.Edit
               DS![Description] = "My Description"
               DS![CategoryName] = "My Category"
            DS.Update
   
            ' Print the new contents of the recordsets.
            Debug.Print
            Debug.Print "Snapshot:"
            Debug.Print "   CategoryName: " & SS![CategoryName]
            Debug.Print "   Description: " & SS![Description]
            Debug.Print "Dynaset:"
            Debug.Print "   CategoryName: " & DS![CategoryName]
            Debug.Print "   Description: " & DS![Description]
         End Function
   					

3. Type the following line in the Debug window (or Immediate window in versions 1.x and 2.0), and then press ENTER:

   ? TestSnapShot()

   Note that the following text is displayed in the Debug window:

         Snapshot:
            Category Name: Beverages
            Description: Soft drinks, coffees, teas, beer, and ale
         Dynaset:
            Category Name: Beverages
            Description: Soft drinks, coffees, teas, beer, and ale
   
         Snapshot:
            Category Name: Beverages
            Description: My Description
         Dynaset:
            Category Name: My Category
            Description: My Description