Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    object references? (AXP 10.2627.2625)

    How do I (automatically) find out which objects reference another object?

    Ex: I want to remove table A and replace it with tables B and C. Which tool do I use to find all references to A in queries, forms, reports, macros and modules?

  2. #2
    Star Lounger
    Join Date
    Nov 2001
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: object references? (AXP 10.2627.2625)

    I would suggest that you look into Rick Fishers Find and Replace program. The price is certainly right and it is in indispensible tool in my opinion. Go to <A target="_blank" HREF=http://www.rickworld.com>http://www.rickworld.com</A> to download a trial version...

    hth,
    Jack

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: object references? (AXP 10.2627.2625)

    You might try SpeedFerret, which I believe can be found at <A target="_blank" HREF=http://www.SpeedFerret.com>http://www.SpeedFerret.com</A>. I don't have it myself, but I know others who think very highly of it.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: object references? (AXP 10.2627.2625)

    The latest version of Speed Ferret doesn't yet support Access XP, although the upgrade should be announced fairly soon. Version 4.0 only goes up to Access 2000/VB6/SQL Server 7.0.
    Charlotte

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: object references? (AXP 10.2627.2625)

    Hi Mark -

    Speed Ferret lists at $149 and is listed on the website as compatible with Acc 2K (max), so i would guess they need to do an upgrade.

    OTOH, Rick Fishers Find & Replace is $37.

  6. #6
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: object references? (AXP 10.2627.2625)

    now that is what i call synchronicity...

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: object references? (AXP 10.2627.2625)

    On the other hand, Speed Ferret 4.0 works with SQL Server and VB as well as Access and has become a truly impressive application. It is no longer an add-in. Rick Fisher's product is good but limited.
    Charlotte

  8. #8
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: object references? (AXP 10.2627.2625)

    Since i use neither SQL Server nor VB, it looks to me like i would be wasting money. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: object references? (AXP 10.2627.2625)

    For the present, that's very true.
    Charlotte

Posting Permissions

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