Manage table names, flds, queries via reporting structure

J

jason

Access 2000

I would like to be able to generate table reports listing all the TABLE
NAMES, FIELDS and their datatypes in a neatly formatted table.

Additionally I am building up a frightening amount of queries.....I would
also like to cycle through this and neatly associate notes with them to
remind
me of their specific purpose. The naming of the query can only go so far.

I am guessing that the CATALOG feature would be the best way to do this.
Could some experience programmers give me a couple of best practice tips
on how to manage their table structures.

I find that upon returning to my asp and access application after a month or
two I struggle to contextualize where to begin query additions and table
alterations
and hope a catalog method will make me more effective and save time.

- Jason
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,020
Latest member
GenesisGai

Latest Threads

Top