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
problem with ms access queries n model
arpanmukherjee1
XLr8
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
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
Aspiring Novelist
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
XLr8
^^ are views created automatically in MS Access ??
is there a tool like query generator or something ?
can u post a screenshot??
is there a tool like query generator or something ?
can u post a screenshot??