[AccessD] Find and Replace

[Rocky Smolin]

It never let me down. but I'm just one data point.

r

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

> assumed ... .... would be a big risk. (that is how I meant to end the last
> sentence.)
>
> On Tue, Apr 27, 2021 at 7:26 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
>