V
VBSponge
Hi all - im a relative newbie to using Visio - so forgive me if my
query is a bit off-beat.
I am trying to document some MS Access Databases using the Reverse
Engineer tool in Visio. For the most part it is going fine - although
I have noticed Visio only picks up the local tables in a db and not
the linked ones also (this is fine, I have just got the linked ones
from the other databases and added them for the purposes of my
documentation.
The problem I am having is when I try to document some of the more
specific processes used in the database - involving several queries. I
have noticed that not all queries/views show up in Visio - in
particular I need to get a set of Append Queries into the
documentation, but they are not appearing through the Reverse
Engineering wizard (the other queries are, but seemingly not the
append ones).
Short of manually creating the objects in my diagram, can anyone tell
me of another way to bring these queries in - or even if its possible?
It seem strange to me that it doesnt pull through all the queries.
Any help would be greatly appreciated - thanks
P.S: The queries are not linked ones, and in fact some of the not
showing queries dont even involve linked tables either. As far as I
can tell the only commonality they have is they are all append ones.
query is a bit off-beat.
I am trying to document some MS Access Databases using the Reverse
Engineer tool in Visio. For the most part it is going fine - although
I have noticed Visio only picks up the local tables in a db and not
the linked ones also (this is fine, I have just got the linked ones
from the other databases and added them for the purposes of my
documentation.
The problem I am having is when I try to document some of the more
specific processes used in the database - involving several queries. I
have noticed that not all queries/views show up in Visio - in
particular I need to get a set of Append Queries into the
documentation, but they are not appearing through the Reverse
Engineering wizard (the other queries are, but seemingly not the
append ones).
Short of manually creating the objects in my diagram, can anyone tell
me of another way to bring these queries in - or even if its possible?
It seem strange to me that it doesnt pull through all the queries.
Any help would be greatly appreciated - thanks
P.S: The queries are not linked ones, and in fact some of the not
showing queries dont even involve linked tables either. As far as I
can tell the only commonality they have is they are all append ones.