Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Unanswered: The fastest way to feed Access with Server data?

    Hi guys,

    I am looking for the fastest way to feed my reports and forms in Access DB with data from SQL server.
    So far I was using linked tables and than select queries based on them,but they are very slow.
    Much faster are pass-through queries (data I need is to "read only") and I was also thinking about using them to run procedures on the server.

    Also, what is faster:
    - to use pass-through queries to query SQL Server tables
    - to use pass-through queries to query SQL Views
    - to use pass-through queries to run SQL procedures that would select data

    Does anybody had the same problem before and have any tips/suggestions?

    Any help will be trully appreciated.

  2. #2
    Join Date
    Jan 2004
    Romania - Bucharest
    When possible, use stored procedures.

  3. #3
    Join Date
    Jan 2004
    Jersey, UK
    You could create a DTS package to upload your data into Access giving you local tables to work with.

    It won't give you live access to data but you can write a procedure to run the DTS package.

    Regards - Andy

Posting Permissions

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