[AccessD] Find and Replace

[Bill Benson]

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
>>
>