problem with ms access queries n model

[arian29]

I have an ms access file which has around 15 queries and a few tables. It was created by someone else and now i am to take care of it. Now i am having problem relating all the queries and getting the flow. Is there a way where in u can maybe get a diagrammatic representation of the queries and the relationships, dependencies etc in access ? or is there a better way.. pls suggest

[arpanmukherjee1]

relationship diagram is displayed for tables only

u have to get hold of queries only

i was faced with a simiilar situation once.
this can come in handy for long queries::
T-SQL Parser

15 queries r not many. 1 day would be sufficient to know what they are doing

[asingh]

Originally Posted by arian29

I have an ms access file which has around 15 queries and a few tables. It was created by someone else and now i am to take care of it. Now i am having problem relating all the queries and getting the flow. Is there a way where in u can maybe get a diagrammatic representation of the queries and the relationships, dependencies etc in access ? or is there a better way.. pls suggest

You should be able to open each query and see the dependent tables and queries. Also you can select each object and view the dependencies from VIEW.

[arpanmukherjee1]

^^ are views created automatically in MS Access ??

is there a tool like query generator or something ?

can u post a screenshot??