What are the benefits of ADP versus ACCB in Access 2007

Posted on 2007-08-02
Last Modified: 2010-03-19
What are the benefits of ADP versus ACCB in Access 2007, not counting the fact that you can directly modify linked SQL Server tables? I'm looking for what you consider the best online articles or your personal comments. I'm fairly fluent in Access, but am a beginner in SQL Server and ADP. TIA.
Question by:rdperkins
    LVL 77

    Accepted Solution

    If you are starting from here then you should know that MS's current position is that ADPs are at the end of their road and no further development is planned.  Things are now focussed on the AccDb format and of course there are new features in Accdb which are not in either ADP or MDB formats.
    I think MS expect you to be using  or etc to frontend sql server.  Access is being pointed at Sharepoint rather than SQL server.

    LVL 84
    That's really the only benefit, IMO. I'm not sold on the ACCDB format as yet, specifically the multivalued fields. I have no real problem with them, but rather with the inability to easily work with them via code. For my money, I'd rather use the .mdb/.accdb format and build my own connection to the server, and handle it that way.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Show Balance 3 15
    64 bit vba timer module 2 26
    message box formulas 3 17
    restrict users from ODBC useage 5 13
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now