[AccessD] Find and Replace

[Bill Benson]

I promise you it isn’t (doable) in plenty of robust applications I have
seen that store the queries they want to run in a table. Once you start
trying to do search and replace *within* strings of data, stuff goes
sideways real fast, and it is irreversible.

On Tue, Apr 27, 2021 at 9:27 PM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

>
> It’s not super easy, but quite doable and not as hard as you might think.
>
> Jim
>
>
>
> Sent from my iPhone
>
> > On Apr 27, 2021, at 7: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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>