[AccessD] Utility to help replace primary key

At least for the code part you could try using MZ-Tools.

Jeffrey F. Demulling
Project Manager
U.S. Bank Corporate Trust Services
60 Livingston Avenue
EP-MN-WS3C
St. Paul, MN  55107-2292
Ph: 651-495-3925
Fax: 651-495-8103
Pager: 888-732-3909
Text Messaging: 8887323909 at my2way.com
email: jeffrey.demulling at usbank.com


                                                                           
             "Susan Geller"                                                
             <sgeller at cce.umn.                                             
             edu>                                                       To 
             Sent by:                  accessD at databaseadvisors.com        
             accessd-bounces at d                                          cc 
             atabaseadvisors.c                                             
             om                                                    Subject 
                                       [AccessD] Utility to help replace   
                                       primary key                         
             03/08/2006 11:36                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
                  "Access                                                  
                Developers                                                 
              discussion and                                               
             problem solving"                                              
             <accessd at database                                             
               advisors.com>                                               
                                                                           
                                                                           




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




------------------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.
==============================================================================