Find and Replace

[Al Camp]

Can anyone recommend a good Find and Replace product for Access 97.
(I'm really more concerned with the FIND portion, with a good
reporting/printout ability)

I've tried one called Find & Replace in the past, but because it leaves open
each form/report as it does it's FINDing, I always run out of memory before
all my objects have been searched. (even with 1 GB!)

Thanks for any help/suggestions...

Al Camp

 

[John Vinson]

Can anyone recommend a good Find and Replace product for Access 97.
(I'm really more concerned with the FIND portion, with a good
reporting/printout ability)

I've tried one called Find & Replace in the past, but because it leaves open
each form/report as it does it's FINDing, I always run out of memory before
all my objects have been searched. (even with 1 GB!)

Thanks for any help/suggestions...

Al Camp

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

I like Speed Ferret; it's fast and I've never had the memory problems
you describe.

John W. Vinson[MVP]

 

[Ed Warren]

Truly puzzled by the question.

Access is for 'finding' (select) and 'replacing; (update) and/or
transforming (query) data. It is designed to quickly find data using
queries.
Access's reporting capability, for data, is great.

Try building a query to do the finding, and a report to do the printing.

Ed Warren.

 

[John Vinson]

Truly puzzled by the question.

Access is for 'finding' (select) and 'replacing; (update) and/or
transforming (query) data. It is designed to quickly find data using
queries.
Access's reporting capability, for data, is great.

Try building a query to do the finding, and a report to do the printing.

I think Al is trying to find references to fields, queries, variables
and the like in Forms, Reports, and VBA code - not find data stored in
tables. At least that was my assumption!

John W. Vinson[MVP]

 

[Al Camp]

John,
Sorry I didn't get back to you sooner. Thanks for those links, I'll
check them all out.
And thanks also for your Speed Ferret recommendation...

Al Camp

 

[Al Camp]

Ed,
I was referring to Add-Ins for Access that search all your database
objects (forms, queries, modules, etc...) to find references to a particular
name.
If you have to change a field name that's been in use for a while you'd
need to determine in what objects that old name exists, and replace that
name with the new name.
Al Camp