Organizing a database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tanis Dimitrios - 18 Dec 2004 13:19 GMT

I am setting up a database in access 2003 (file format: Access 2000).
After creating the structure (tables, queries, etc) the database looks
messed up with all objects together.

Is there any way to organize tables in folders ????

any ideas?

PS I don't want to have to split my database.

Reply to this Message

Tim Ferguson - 18 Dec 2004 17:08 GMT

=?Utf-8?B?VGFuaXMgRGltaXRyaW9z?= <TanisDimitrios@discussions.microsoft.com>
wrote in news:74E1D01A-937A-490C-93E0-BDD1E6FB4DF9@microsoft.com:

> Is there any way to organize tables in folders ????

You can't mess about with the tables pane in the database window, but you
can create new groups in the sidebar-thing on the left, and put shortcuts
to your favourite objects there. Look for help on "About ways to use the
Database window".

In any case, once your project is up and running, there should be no need
to mess about with tables anyway. All access to data should be happening in
queries and forms, and you can name these so that they group
alphabetically. For example, you could have your data entry forms begin
with "frm" and dialogs begin with "dlg" so that they sort together.

> PS I don't want to have to split my database.

It won't make any difference to the question you have posted, but the truth
is that whatever you are doing with this database, you _do_ want to split
it.

Hope that helps

Tim F

Reply to this Message

Duane Hookom - 18 Dec 2004 17:13 GMT

You have the ability to set up groups in the database window. I trust your
users never see your database window and the only reason to group objects is
to meet your own needs.

Signature

Duane Hookom
MS Access MVP

>I am setting up a database in access 2003 (file format: Access 2000).
> After creating the structure (tables, queries, etc) the database looks
[quoted text clipped - 5 lines]
>
> PS I don't want to have to split my database.

Reply to this Message