[AccessD] Find and Replace

[Bill Benson]

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
>