I am planning a career break so recently I am having to consider how to make my database applications easier for others to understand and easier for me to understand after being away for 14 months, possibly with some changes.

I am considering writing a description for each database object and then using the Groups to categorize all the objects associated with each form (So each form would have a group and any object involved in the form would be in there). I would like to avoid any paper or external documentation if possible.

I was wondering how anyone else approaches this and if there were any better ways of doing this. I am using Access 2003 currently so I don't know if the newer versions have improved features in this regard but would like to hear any version specific comments please.

Its a great idea if you have the patience to do it. Tables can belong to more than one group. Which is ideal for Objects that are secondary to a Group....so in GroupAccounts You would clearly want Invoices, InvoiceDetails but also perhaps Clients which would also fall into other Groups. I wish I had used it at the outset in one or two projects which have grown. Groups are Not the objects themselves, so deleting them in a group removes them from the Group only.

Version 2007......I was completely baffled by the way db objects were grouped sorted and called ...... beyond me!

Enjoy your 14 month break.....if you are passing thru Spain, call in!

HTH


Z