Changing a column globally

[mdexter]

Hi All,

I need to change the word "Category" to "Severity" on all table columns, fields, reports forms, etc. Globally make this change but I need to do it safely without breaking any of the refer to or send to links.

Is there somewhere in Access I can go to make this change one time and have it take effect everywhere. Really just looking at the labels of this word everywhere "the name" not so much care about the "control source" .

Well to be a good developer I should change it everywhere but I did not create the DB so I have no way to be sure where it shows up in every instance.

Any help would be great.

Thanks,
Mike

 

[pbaldy]

Google a free tool called V-Tools, which has a find/replace utility I hear works well.

 

[SOS]

Welcome to AWF

You can use the Free V-Tools which has a tool in it called Total Deep Search. It has a replace checkbox you can check and it will replace what you specified with the term you want.

 

[SOS]

Google a free tool called V-Tools, which has a find/replace utility I hear works well.

Ooh, just missed getting it in (but I provided the link, which took the extra time )

 

[gemma-the-husky]

but surely all you REALLY need to change is the text description on the forms/reports using this field - it doesnt really matter what the field is called in the table

 

[SOS]

it doesnt really matter what the field is called in the table

If it was my boss, it would matter, so I can relate if it is necessary.

 

[mdexter]

Hey guys thanks that seems to work very nicely. Thats a great tool. Almost too great. I can see where this might be dangerous. But exactly what i was looking for.

I have one issue. I have a CHART that used to say: Issues by Category and display three categories 1,2,3 with seperate values for each.
Now the CHART still says issue by Category only now it has one category lumping everything into the one categrory.

 

[mdexter]

Actually i figured it out. There was a small piece deep find did not touch and should have. But I fixed it and I appear to be running again without errors. Thank you all for the help.

 

[mdexter]

but surely all you REALLY need to change is the text description on the forms/reports using this field - it doesnt really matter what the field is called in the table

On this one I did not want to have to remember for an eternity Category = Severity. I like to be more thourough in my solution so that someone else could come in and pick up where I left off. But your right I did not have to.

 

[Atomic Shrimp]

Too late for this advice now, but for viewers watching in black and white... BACK UP any database before you do any kind of global search-and-replace on it, better still, test the changes on a copy of the DB first, then back up the live one, then make the changes.