Results 1 to 5 of 5
  1. #1
    JamesP
    Guest

    Removiong Objects

    Hello

    I am a student who is currently working in a co-op part of my schooling. I have inherited a large database that was created and built on by 3 previous students. There has been no professional supervision and the result is, well, interesting! <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15>
    One of my problems is that there is a lot of tables, queries and modules that I am pretty sure are no longer being used by the database. The database is so large and my experience is so limited that I am afraid to remove objects with out being sure of the items obsolescence.
    Is there a way that I can keep a count on the number of times an object has been accessed?
    Or, is there another way to insure that an object is no longer in use?

    Thank you!

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removiong Objects

    Dear James,

    I know it

  3. #3
    JamesP
    Guest

    Re: Removiong Objects

    Thanks Rupert

    Simple is good. :]

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removiong Objects

    If you can get your supervisor to fork over the $, get <A target="_blank" HREF=http://www.fmsinc.com/products/analyzer/index.html>Total Access Analyzer</A> (click on the name to go to a description of it). Among many other things it will give you many different types of cross-references of your database. Also handy if you're cleaning up "messes" created by others is the fact that it provides a detailed breakdown of problems in your database.

  5. #5
    JamesP
    Guest

    Re: Removiong Objects

    Thanks!
    I have already sent out the request! :]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •