Results 1 to 5 of 5

Thread: adp (2002)

  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    adp (2002)

    What are the advantages to using an adp as opposed to an mdb front-end linked to tables on a sql server back-end

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

    Re: adp (2002)

    The main advantage is speed. The odbc links to SQL Server are slower than the direct window into SQL Server that the adp provides.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adp (2002)

    Thank you, Charlotte. And, what are the disadvantages [img]/forums/images/smilies/smile.gif[/img]?

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

    Re: adp (2002)

    They are pretty significant, which is why most developers are still doing MDBs. The biggies from my point of view are:<UL><LI>The learning curve associated with SQL Server
    <LI>Having to do all the simple Jet query designs in Views or Stored Procedures in SQL Server
    <LI>The limitations on Forms and Reports in ADPs[/list]IMHO, the bottom line is that even if you need a SQL database becasue of size, reliability requirements or performance needs, in many cases using an ODBC link to a SQL table works just fine. Only if you need the absolute best performance does an ADP become compelling.
    Wendell

  5. #5
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Lakewood, New Jersey, USA
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adp (2002)

    Thank you, Wendell. You've convinced me. In our situation, the performance using an mdb linked to sql server back end is generally good enough (when I don't mess it up by adding unnecessary sql statements that get executed unexpectedly [img]/forums/images/smilies/smile.gif[/img]). I appreciate the feedback.

Posting Permissions

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