I am building a database and it seems that I will have a large number (cc. 100) of queries - many of them will dependend on each-other several levels deep.
What is your practice to keep them organized?
I use Access 2000 now and I know I can use the description field - but what exactly is the convention you are using not to get hopelessly lost?
Is it worth considering using Access 2002 with SQL2000 just for the sake of stored procedures ? I guess they would help a lot keeping the 'queries' organized. (Just purely from the point of building the database - not counting money and performance issues.)
Thanks for the help.
SWK
What is your practice to keep them organized?
I use Access 2000 now and I know I can use the description field - but what exactly is the convention you are using not to get hopelessly lost?
Is it worth considering using Access 2002 with SQL2000 just for the sake of stored procedures ? I guess they would help a lot keeping the 'queries' organized. (Just purely from the point of building the database - not counting money and performance issues.)
Thanks for the help.
SWK
