[AccessD] Find and Replace

Jim Dettman jimdettman at verizon.net
Mon Apr 26 04:38:05 CDT 2021


 It's a shame that Rick's tool is now un-supported.

A number of people and myself have tried to track down someone that would be
able to release the source code, but to no avail.   Apparently, Rick felt
the code was messy and didn't want others to see it, but from my viewpoint,
it did the job and did it very well.   I wish he was still here to be able
to tell him that (we assumed that he has past).

If you can't get it working as David suggested, there is a new F&R utility
out there:

https://accessdevtools.com/product/find-and-replace/   by Philipp Stiefel

This is a almost brand new utility (been out for a year or two) and is
written in .Net, unlike Rick's tool, which was VBA based.  

and for documenting/pulling a DB apart, there Total Access Analyzer from
FMS, Inc.

http://www.fmsinc.com/MicrosoftAccess/BestPractices.html

Jim.

-----Original Message-----
From: AccessD On Behalf Of Rocky Smolin
Sent: Sunday, April 25, 2021 11:05 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: [AccessD] Find and Replace

One of my (last) clients has a major redesign of a system I wrote for him
to run one of his three businesses. It gives me a chance to clean up a lot
of stuff that's been left over from previous revisions.

I used to use Fisher's Find and Replace but apparently he went away leaving
me with an orphan app that doesn't work. It was a brilliant piece of work
in its day but it's dead now.

Is there something similar - not just to find a replace, but to tell me if
a query or a report, or a module is no longer referenced in the database?

MTIA

Rocky
Beach Access Software
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list