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 thanksAnonymous
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.comAnonymous
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 JamesAnonymous
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>.