Folders

[Guest]

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

 

[Joseph Meehan]

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

Could you provide some examples of what you want to do?

I suspect the answer to your question is partly in understanding
databases and partly in using queries.

 

[Guest]

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...

 

[Joseph Meehan]

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...

I would think that you would want to keep everything in one database.
Those items that relate to different stages should be related to a stage
table. From there it is easy to view any stage information.

I still don't have much of a feel for the data. That is why I can't
really offer a positive answer or comment. While I have no specific reason
for thinking this, I just can't get rid of the idea that there is a table
design issue here and things may not be properly normalized.

 

[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