[AccessD] Utility to help replace primary key

Susan,

I use Rick Fisher's Find & Replace for doing this kind of thing.  Don't
worry about buying it and having it not turn out to be helpful just for this
task.  You should have a find and replace tool in any case.

Another possibility is SpeedFerret, which I haven't used.

I believe Find & Replace is about $40, and SpeedFerret is about $150.

Dan 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Geller
Sent: Wednesday, March 08, 2006 11:37 AM
To: accessD at databaseadvisors.com
Subject: [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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com