[AccessD] Utility to help replace primary key

I am working with a customer that has a database where the main person
table uses SSN as the primary key.  Yikes, yuck, ugly etc. I'm
inheriting this mess from someone else. 

I want to create a new autonumber field in that table to use as a
primary key instead, but once I do that I'm going to need to go in and
fix all the queries and reports that reference the SSN field and
especially those that link to it.  

My question is: Is there some kind of utility that could help with this
chore?  Even if there was something that could find all places the SSN
field was referenced, that would be good.  

Thanks.

--Susan


Susan B. Geller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568