Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    42

    Unanswered: Connecting to external Access db question

    Is there a faster way to retrieve data or connect to an external access database other than below?

    Dim db as database
    Dim rst as recordset

    Set db = CurrentDb

    Set rst = db.OpenRecordset(strTable, dbOpenDynaset)

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    Faster in terms in amount of code to write or faster in how records are processed.

    The example you gave uses DAO

    I have been told the ADO (ActiveX Data Object) is to be faster in the processing of information and is avaliable in Access 2000 or higher

    S-

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    what do you want to achieve?
    read-only (="retrieve"), or link (="connect"), or import (another sort of "retrieve")
    all data/all fields or a subset of either/both ?
    all at the same time, or just the record of interest?
    must you have write access to the remote table?
    are there other users writing to the data when you do this?

    izy
    currently using SS 2008R2

Posting Permissions

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