Entity Relationships

[Guest]

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!

 

[Van T. Dinh]

Try

* Find and Replace
http://www.rickworld.com/products.html or

* Speed Ferret
http://www.moshannon.com/

 

[Ron Hinds]

Total Access Detective from FMS Inc. will do the trick:
http://www.fmsinc.com

 

[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?

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!!).