Changing Company Name

A

Amtrack

How do you change a company's name in the database and still be able to see
all records entered under the previous name when you use the new name?
 
W

Wayne-I-M

Hi

If you have not used the company name as the primary field and you have not
used the name in a filter it should not make any difference.
 
J

Jerry Whittle

Like Wayne said, if you you did not use the name as part of the primary key,
it shouldn't matter in a properly normalized database. Properly normalized
you should have something like a Companies table where the company name is
entered once and only once for the entire database.

If you did use the company name as a primary key, go to the Relationships
window and set the relationships between the primary key and all tables with
a company foriegn key field. Then turn on Referential Integriy with Cascade
Update on. If you can get referiential integrity to work, Access will
automatically update all the company name changes made in the parent table.

If you haven't normalized your data, you'll need to manually find and
replace the company name in all tables where it is entered.

What ever you do, make a complete backup of the database just in case things
go terribly wrong.
 
J

Jerry Whittle

Disregard my previous answer. I didn't read your question properly. I now see
that you want to keep the pervious company name and not update it in records.
Possibly the best way to do this is create a new company for new records. Of
course this will be a PITA when you wish to see all the records for this one
company that has two names.
 
J

John Vinson

How do you change a company's name in the database and still be able to see
all records entered under the previous name when you use the new name?
Click to expand...

That depends on where it is in the database. What's the structure of
your Table? Do you have the company name in a Lookup Field? Do you
have a table of company names?

John W. Vinson[MVP]
 
Top