Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dynaset?? (Access 2000)

    Hi Everyone,

    I have tried finding information on dynaset in lay person term, help!! what is it?

    Thanks Kindly,

    Kerrie <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Dynaset?? (Access 2000)

    A dynaset is a DAO recordset that is fully editable and allows random access to its records. There are other kinds of recordsets that are read only or that only allow you to step through them in one direction. Is that what you needed to know? In Access 2000, you have to have a reference set to the DAO library before you can create a dynaset--the ADO equivalent is a keyset.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dynaset?? (Access 2000)

    Access is a container for data via TABLES. In order to work with this data, there are certain OBJECTS that allow you to view as well as manipulate this data. Snapshot and Table are two such OBJECTS, and so is the DYNASET object you asked about. Think of these three types of OBJECTS as packages. Each package lets you do certain things in a different way from the other via their properties and methods (or behaviors). In particular, the DYNASET OBJECT allows you to view and manipulate data as a packaged object that INDIRECTLY accesses the data in the tables -- you change the data, then the DYNASET OBJECT changes the data in the tables for you. Just to compare, the TABLE-TYPE OBJECT allows you to DIRECTLY access the data in the tables, without the "buffer" that the DYNASET OBJECT provides. There are advantages and disadvantages to both, depending on what you want to do. Everything discussed here is all part of the RECORDSET OBJECT, and it is in learning this that you can master working with the different RECORDSET OBJECTS, both in DAO as well as in ADO.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •