How to track a column being used in 100 different forms

[goyalpr]

I'm doing a maintenance work on an access'97 database. We have to get rid of a column (NbrAssigned) from a particular table. But before deleting this column we have to make sure that it is not being used anywhere in the project.

The problem is, this column is referenced in plenty of forms (rather than being used inside the code) hence making it impossible to track using a global search.

I would really appreciate if someone could tell me how to track the usage of this column in various forms.

Thanks

 

[RichMorrison]

You buy "Speed Ferret" from Black Moshannon Systems.

Look it up with Google.

RichM

 

[llkhoutx]

I use Speed Ferret regularly. You'll be surprised how often seemingly innocuous character strings appear in esoteric ways.

It can be purchased via the internet.

Speed Ferret finds them all and lets you select which you want to change.

 

[goyalpr]

Thanks a lot, RichMorrison and llkhoutx.

The software is really great indeed. You saved me from lots of trouble.

Cheers
Prashant