Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    dbOpenRecordset vs. dbOpenSnapshot (Access2000)

    Need some info that I can't find in the help.
    What is the advantage of one over the other and which is faster.
    Thanks,
    Scott

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: dbOpenRecordset vs. dbOpenSnapshot (Access2000)

    I think there is some confusion here, for dbOpenRecordset doesn't exist.

    OpenRecordSet is a DAO method that applies among others to the Database, TableDef and QueryDef objects. One of the arguments of this method is Type, to specify what kind of recordset you want to open. Possible values for Type are:

    dbOpenDynamic
    dbOpenDynaset
    dbOpenForwardOnly
    dbOpenSnapshot
    dbOpenTable

    If you want to be able to add, edit and delete records, use dbOpenDynaset. This will work both with tables/queries in the database itself as with linked tables that reside in another Access database.
    If you only want to retrieve records without editing them, and you want to be able to move forwards and backwards, you can use dbOpenSnapshot.
    If you will only run through the records once, from first to last, and you don't need to edit them, you can use dbOpenForwardOnly.
    dbOpenSnapshot and dbOpenForwardOnly place fewer locks on the table, which can be handy in a multi-user environment.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: dbOpenRecordset vs. dbOpenSnapshot (Access2000)

    Hans,
    My typo <img src=/S/blush.gif border=0 alt=blush width=15 height=15> I did mean dbOpenDynaset vs. dbOpenSnapshot
    Thanks for the explaination

Posting Permissions

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