PRB: Dynaset, Snapshot, and Table Objects No Longer Available

RESOLUTION

• Replace references to the older objects, while retaining lines of code such as these:

         Dim DB As Database
         Set DB = OpenDatabase("Biblio.mdb")
  						

  For example, instead of this old code:

         Dim DS As Dynaset
         Dim SS As Snapshot
         Dim TB As Table
  
         Set DB = OpenDatabase("Biblio.mdb")
         Set DS = DB.CreateDynaset("Authors")
         Set SS = DB.CreateSnapshot("Authors")
         Set TB = DB.OpenTable("Authors")
  						

  Use this new code:

         Dim DB As Database
         Dim RS1 As Recordset
         Dim RS2 As Recordset
         Dim RS3 As Recordset
  
         Set DB = OpenDatabase("Biblio.mdb")
         Set RS1 = DB.OpenRecordset("Authors", dbOpenDynaset)
         Set RS2 = DB.OpenRecordset("Authors", dbOpenSnapshot)
         Set RS3 = DB.OpenRecordset("Authors", dbOpenTable)
  						

  -or-
  
  
• Retain the older syntax and change the Data Access Object (DAO) Type Library that your program uses. Although Microsoft recommends the first method for future compatibility, using the older syntax is useful for compiling code written in previous versions of Visual Basic in version 4.0 with a minimal number of changes. To change the DAO Type Library:
  
  
  1. Choose References from the Tools menu in Visual Basic.
  2. Clear the Microsoft DAO 3.0 Object Library selection.
  3. Select the Microsoft DAO 2.5/3.0 Compatibility Library.