[AccessD] Find and Replace

Rocky Smolin rockysmolin2 at gmail.com
Tue Apr 27 21:54:10 CDT 2021


I used it for years  Brilliant piece of work. It did modify the code. I
haven't had a call for it for quite a while.  But when I did need it and
tried to run it a couple of years ago, it wouldn't load.  And Fisher seems
to have disappeared. So that's that.

r

On Tue, Apr 27, 2021 at 4:27 PM Bill Benson <bensonforums at gmail.com> wrote:

> That F & R utility looks like it makes some strong claims. I have always
> wondered if - and if so, how - any tool could change object names in VBA
> code however. It would seem to me to be extremely unlikely to find all the
> ways strings could be put together and used to reference object names
> within VBA code. Hence, I have long assumed major find and replace
> operations in heavily code dependent databases.
>
> On Mon, Apr 26, 2021 at 5:38 AM Jim Dettman via AccessD <
> accessd at databaseadvisors.com> wrote:
>
> >
> >  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
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> 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