Folders

A

Andy

Is there anyway to have some form of folders witihin sections such as tables
and queries in Access. When utilising one large database, this would make
organisation and sorting infinitely easier, rather than have to write out to
separate databases.

Thanks
 
A

Andy

I have one database with a number of queries and tables, all of which are
relevant to the one piece of work and hence in the same database. There are
however multiple stages within the work and I would therefore like to be able
to arrange queries and tables into folders witihin the one database.

Short of having multiple databases for each stage of the work with linked
tables, folders were the only other organisational method...
 
L

Larry Daugherty

I think the direct answer to your question is "No".

However, there are some very reasonable ways to tailor your
application such that it makes sense to the user:

First is the judicious use of Switchboards into a hierarchy and
sequences such that your user can navigate into the correct part of
your application to do the current task.

Second is that you never require your users to run queries any more
than you'd invite them to enter data directly into tables. FWIW the
query window is empty in any application I deliver. All queries
should be implicitly or explicitly run from forms which are the main
interface for the user. Each form, subform and report can contain its
query such that it never appears in the query window. That protects
you from a user's inadvertent execution of the query and the even more
to be dreaded case of using the same query in more than one form or
report and then tailoring it to the last form or report you designed.

HTH
 
Top