can u suggest a program to make a database diagram?

[ultra2]

I have an Access database. I need to make a diagram on which the tables and the relations are drawn.
can u suggest an easy to use tool for that?

[si_the_geek]

There is a decent one in Access itself, just go to "Tools" -> "Relationships".

You can add all the tables you want (and set the size/position of each), and add the relationships between the tables by dragging the field from one table to the other.

You can set the type of join for the relationships, and set whether or not referential integrity should be enforced (if you only want the diagram, you should not do this).

[ultra2]

thx very much, I tried out and it is really good, only 1 problem I have only 1 arrangement can be saved, and my db has more than 100 tables, and I would need more layouts in order to see only the tables I work with. the program has 10 modules and each of them belongs about 10 tables, so when I work with a certain program module a need to see only that 10 tables...so I need 1 arrangements for each program module..