Word filter

[Louie Warren]

I have a classified database. I want to sanitize it and
move to an unclassified system. I need to check data,
forms, etc. for occurances of words and phrases that would
make it classified. Is there a tool out there that does
that, or do I need to manually go through everything?
Thanx!

 

[lwarren]

Is there such a thing for an Access database?

 

[Mike Painter]

It is fairly easy to develop such a utility. You need a table (known as a
stop list) which contains all the words and phrases you want to mark or
eliminate. Then loop through the stop list and use the Replace function on
the text.