Entity Relationships

P

PeterM

Is there a way to determine where a table is used within a database? Which
forms? reports? queries? macros? modules? etc.

Because of unique requirements of our host, we cannot build/use
relationships in Access which means O've had to manually program referential
integrity...but that's another story.

Is there a way to determine this?

Thanks in advance for your help!
 
A

Albert D.Kallal

In access 2003, you can right click on any table, and go "view dependences".

However, this approach is limited, since code often will prompt, or set a
value.

strTable = "tblCustomers"


set rstCust = currentdb.OpenRecordSet(strTable)

In the above code, we really can't tell what particular value strTable has
unless we run the code. So, you can't really view all dependencies. However,
ms-access does the best it can to show those dependences.

So, ms-access will try it best..but there is limitations to the approach.

Do note that ms-access does force you to use track autoname correct..and
that means you should turn it off after when done...
Is there a way to determine this?
Click to expand...

If you used code...hum...boy, not a easy task....

The "first" thing I look for when looking at a application that is not
mine..is a NICE ER diagram!! (I bet you feel that way too..but you situation
is such that you don't have one!!).
 
Top