none
ACCDB vs. MDB

    Question

  • I've heard stories of performance issues with ACCDB format in AC2007. Therefore, my next app will likely stick with the MDB format. However, I am wondering what I'm missing by moving away from the ACCDB format. Here is a partial list. Can anyone add to it ?

    1) Ability to embed a report in a form (aka a subreport in form)
    2) New Navigation Control (think of as combination of tab control and subform)
    3) Trusted Documents which at least being some sanity to the silly Trusted Policies
    4) Application Parts to help modularize and make it easy to quickly add templates below the file level
    5) New WebBrowser control.
    6) ACCDB required for Sharepoint deployment/sync

     

    Saturday, December 04, 2010 3:12 PM

Answers

  • Here is a link from a post by another access MVP. It discusses security with accdb and accde.

    Workgroup security, which is what MDW's use, is deprecated in the new .ACCDB format (hint-hint). If you are interested in security based on Active Directory groups, this blog post may be of interest: http://www.accesssecurityblog.com/post/Securing-Access-databases-using-Active-Directory.aspx

     Tom. Microsoft Access MVP

     

    " It's almost as if you must do the role-checking in the OnLoad events of forms and reports."

    Yes, some developers do that. I have done it in one app.


    Jeanette Cunningham (Access MVP) Pakenham, Victoria Australia
    • Marked as answer by Bessie Zhao Monday, December 13, 2010 11:29 AM
    Sunday, December 05, 2010 8:43 PM

All replies

  • We have been having a General Performance psoting going since Novembeer 18th.  Albert is an expert on your problem.  the are two other Microsoft Experts who am also following the question (Vanderghast and Tony).  I posted a link to this question on General Performance question.   I'm sure somebody will get back to you very soon!

    General Performance question

    http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/8e183233-d477-4732-bff6-7e202fcf6add/


    jdweng
    Saturday, December 04, 2010 5:38 PM
  • Joel - I am more concerned about the FUNCTIONALITY issues, rather than performance at this time. Also, I think I forgot to include MULTIVALUE columns and ATTACHMENT columns to the list of features only supported under ACCDB.

    What I am trying to ascertain: How to respond to someone criticizing the move to MDB from ACCDB....i.e. does the increased functionality offset the performance "hit". That's the issue.

    Saturday, December 04, 2010 5:48 PM
  • What performance hits? I am not aware of any performance hits with the new accdb and accde file formats in A2007. Perhaps you are thinking of the early times after the release of A2007 which had quite a list of bugs. Most of those bugs have now been fixed and service pack 2 brings you up to date with those fixes. I have been using A2007 for developing accdb and accde apps for clients for the last 3 years and I love it. I can't think of even one performance hit.


    Jeanette Cunningham (Access MVP) Pakenham, Victoria Australia
    Saturday, December 04, 2010 7:49 PM
  • Thanks Jeanette....and that's good to know: the issues were transient and subsequently fixed.

    Still, there's the functional considerations....and I also forgot about the fact that ACCDB removes workgroup security. How have developers been working around that one ?

    It appears MDB is only good if you want compatibility with AC2003 and also want workgroup security. However, given the free AC2007 run-time, the need for MDB now reduces to the workgroup security.

    Am I missing something in this picture ?

     

    Saturday, December 04, 2010 9:06 PM
  •  That sums it up. The interesting thing about workgroup security is that we can manage without it if we want to use accdb or accde. I'm not aware of any accepted workarounds to replace workgroup security.


    Jeanette Cunningham (Access MVP) Pakenham, Victoria Australia
    Sunday, December 05, 2010 6:11 AM
  •  The interesting thing about workgroup security is that we can manage without it if we want to use accdb or accde.


    Jeanette Cunningham (Access MVP) Pakenham, Victoria Australia

    Well wait minute..."we" being developers ? What about the users ?
    My current clients want control over who gets to update, who gets to report, etc.

    The ribbon can be configured to do this with some programming. However, if you take the elegant GUI of the Northwind 2007 database, with all of the embedded linkages, it is not practical to handle functional security by controlling the menues. It's almost as if you must do the role-checking in the OnLoad events of forms and reports.

     

    Sunday, December 05, 2010 5:51 PM
  • Here is a link from a post by another access MVP. It discusses security with accdb and accde.

    Workgroup security, which is what MDW's use, is deprecated in the new .ACCDB format (hint-hint). If you are interested in security based on Active Directory groups, this blog post may be of interest: http://www.accesssecurityblog.com/post/Securing-Access-databases-using-Active-Directory.aspx

     Tom. Microsoft Access MVP

     

    " It's almost as if you must do the role-checking in the OnLoad events of forms and reports."

    Yes, some developers do that. I have done it in one app.


    Jeanette Cunningham (Access MVP) Pakenham, Victoria Australia
    • Marked as answer by Bessie Zhao Monday, December 13, 2010 11:29 AM
    Sunday, December 05, 2010 8:43 PM
  • Thanks Jeanette and Tom....greatly appreciated.

    Tom - One of my clients is in a Citrix login environment.....I wonder if your Active Directory API calls will fail in that scenario ? Also, while we are on that topic, will there be any issues of running an AC2007 app under Citrix via the access runtime ?

    Monday, December 06, 2010 12:57 AM
  • Syswizard wrote:

    Thanks Jeanette and Tom....greatly appreciated.

    Tom - One of my clients is in a Citrix login environment.....I wonder if your Active Directory API calls will fail in that scenario ? Also, while we are on that topic, will there be any issues of running an AC2007 app under Citrix via the access runtime ?

    Given that Citrix is running on top if Windows Server this means Active
    Directory and A2007 runtime shouldn't make a difference.

    Tony


    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
    For a convenient utility to keep your users FEs and other files   updated see http://www.autofeupdater.com/

    Tuesday, December 07, 2010 12:02 AM
  • I don't have access to a Citrix environment but I don't see why it wouldn't work.

    Perhaps you could download the sample code from my blog post, and try it out. Please post back what you find.


    -Tom. Microsoft Access MVP
    Tuesday, December 07, 2010 3:23 AM
  • Given that Citrix is running on top if Windows Server this means Active
    Directory and A2007 runtime shouldn't make a difference.

    Tony


    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
    For a convenient utility to keep your users FEs and other files   updated see http://www.autofeupdater.com/

    Hey Tony ! Thanks for responding. How does AutoFEUpdater work in a Citrix environment ? Can Server drives be referenced from the client side ? If not, I don't see how your slick utility could work then.
    Tuesday, December 07, 2010 4:50 AM
  • Syswizard wrote:

    How does AutoFEUpdater work in a Citrix environment ? Can Server drives be referenced from the client side ? If not, I don't see how your slick utility could work then.

    Yes, the network shares are setup by user.  So no real difference
    between logging onto a local PC vs logging onto Citrix/Terminal Server.
    Also see http://autofeupdater.com/pages/terminalserver.htm for more
    information.

    Tony


    Tony Toews, Microsoft Access MVP
    Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
    For a convenient utility to keep your users FEs and other files   updated see http://www.autofeupdater.com/

    Tuesday, December 07, 2010 7:34 PM