Change primary key in a linked access table

sonmic
sonmic used Ask the Experts™
on
Hi,
I have a linked table in an access database where, temporarily, part of the primary key must be changed (imported from excel with false information).
Is this possible?

groeten
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
if the table has no relationships with others, then as long as new value is still unique there shouldnt be any problem
if it's related to other tables, then the above applies, plus you need to set cascading updates in the relationship designer, so changes in the primary key on the main table will update (cascade) that value automatically in related tables
hope that was clear enough

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial