Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What happened to 'Dynasets'? (Access 2002)

    Although Access 2002 help files don't alude to the results of a "run" query as as dynaset, several of the earlier Access 2002 tomes I have as "excellent" references do say "the resulting dynaset". Please advise me where "dynasets" went to and/or does this term still apply i.e. when you view records in a table, you're looking at a "datasheet"; when you view records as a result of a query, you're looking at a "dynaset". Thanks in advance for any input.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: What happened to 'Dynasets'? (Access 2002)

    Only some types of recordsets are dynasets - you have to dig into DAO and ADO to begin to get a feel for the difference. In addition, it depends on whether the results of the query are updateable. In general, if the query is updateable, then the recordset is considered a dynaset. In point of fact, I think Microsoft is moving away from the general use of the word, and only using it in specific situations. If you do a search for dynaset in Help, you should see two topics to choose from, and the second topic is the only actual mention of the word that I found.
    Wendell

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

    Re: What happened to 'Dynasets'? (Access 2002)

    The term is peculiar to DAO recordsets. ADO uses keysets.
    Charlotte

Posting Permissions

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