Share via


Access Best Practices Guidelines

Recently a MCS consultant asked the following question on an internal Access Discussion alais:

My customer is looking for either a document on 'general best practices when using Access 2003' and/or a document on 'best practices for coding in Access 2003.' Before I sit down and start trying to create the documents from scratch, I'm wondering if anyone is aware of any documents that already exist that might fit the bill.

The following articles were recommended: 

What articles would you add to the list?

Edited June 12, 2007 to fix URL to the Jet article.

Comments

  • Anonymous
    June 11, 2007
    Any news on the Access 2007 runtime? I hope you Microsoft guys realize that there are developers with deadlines all around the globe, desperately awaiting the runtime.

  • Anonymous
    June 12, 2007
    I'm also waiting for Access 2007 runtime? Could you at least give us your deadlines for it so that we can adjust ours? : )

  • Anonymous
    June 12, 2007
    Second and third link point to the same url. Could you plese check this? Many thanks

  • Anonymous
    June 12, 2007
    Okay forget the runtime. A month ago you said 2 weeks. No offense but the richest company in the world can get this done? Or is it because the big marketing push is over and now on to Office 2010?

  • Anonymous
    June 13, 2007
    Quite a good list of links. Tony's performance faq here is another gem I would recommend: http://www.granite.ab.ca/access/performancefaq.htm Albert D. Kallal Edmonton, Alberta Canada kallal@msn.com

  • Anonymous
    June 13, 2007
    Thanks for the info!

  • Anonymous
    June 13, 2007
    Hello: Ok, so it's disingenuous of me, but what about this? <g> http://www.mvps.org/access/tencommandments.htm Or a more straightforward version of the same... http://www.accessmvp.com/djsteele/AccessTenCommandments.html Cheers!

  • Anonymous
    June 13, 2007
    Please when exactly is the Access 2007 runtime going to be released? If not soon, is there an alternative?

  • Anonymous
    June 14, 2007
    Can one design his/her own database template for MS Access ? If yes, how? thanks James

  • Anonymous
    June 14, 2007
    The Access Developer Extensions has the ability to generate Access Template (accdt) files. You build your db, specify the images, description, and hammer the spit it out button. Should be straightforward once the have the ADE <sigh>.