[AccessD] Find and Replace

[Jim Dettman]

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