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: 

• Description of Database Normalization Basics
• How to keep a Jet 4.0 database in top working condition
• How to optimize Office Access and Jet database engine network performance with Windows 2000-based and Windows XP-based clients
• Best Practices When Using Microsoft Office Access 2003 in a Multi-user Environment
• TechNet Webcast: Managing Access Applications Inside an IT Organization by Zac Woodall

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>.