Usage

[Steve]

Hi

I have inherited a Large Access Database with lots of
tables and queries etc, is there a way that I can run
something(presumably code!) that will tell me which forms,
tables etc are NOT been used. I think that this will help
me in finding my way around this.

Also !

In the Relationships of this database there seems to be
the same tables with the same relationships...for eg

Tbl Clients
Client Id

Order
Client Id

Order_1
Client id

The Order table and order_1 are BOTH going to the clients
table....is this normal ??

Thanks For Any Help on this
S

 

[Cheryl Fischer]

Total Access Analyzer, a third-party product, does this very well. See
their web site:

http://www.fmsinc.com/Products/analyzer/index.html