ODBC, OLE DB, SQL Pass through- differences, pros, cons please....

Posted on 2007-10-09
Last Modified: 2008-01-09
I am looking into ways to connect to a SQL server 2000 database from Access.

Could someone give me PRO's & CONS of connecting via ODBC as compared to OLE DB?
 Additionally- Can much of the same be done with SQL pass through queries?

 I am looking for the easiest way to get look-up only access to some SQL server 2000 tables and views from a split Access 2000 database of about 40 users.  

Any info appreciated as I try to learn this.
Question by:snyperj
    LVL 77

    Accepted Solution

    If you have an mdb frontend then for linked tables you will be using ODBC not OLEDB.  You don't have a choice.

    If you use an adp frontend you use oledb. You don't have a choice.

    LVL 18

    Assisted Solution

    For 40 users with read only access you'd probably be better of using pass through. While not as easy as linked tables, the performance and decrease in network traffic would be worth it.

    Author Comment

    thanks for the advice

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now