Customizing an online Template

[Guest]

Good morning all. Thank you in advance for any help you can lend on this
question.

I downloaded a template for order management and would like to change
"Customers" to "Clients". Is there a way to change this name in all tables,
reports, forms and queries at the same time and not effect relationships?

 

[Pat Hartman\(MVP\)]

If you are using A2K or newer, the Name Auto Correct feature will do some of
this for you. It will propagate name changes from tables to queries, forms,
and reports. It will not change any VBA code so it will not change SQL
strings build in code. You will need to use the search and replace feature
to modify all your code.

To use this feature effectively, make absolutely certain that you have
applied the latest patches for your version of Access. This is particularly
important for A2K which was exceptionally buggy. Make at least one backup
of your application and put it in a safe place. Then turn on the Name Auto
Correct feature (Tools/Options). Test your application thoroughly and when
you are certain that it is still functional, turn the option off. It is
best to leave it off due to the overhead it adds.

You will need to change all your captions yourself on the forms and reports.