[AccessD] Utility to help replace primary key

Incidentally, you don't need to rush to replace your queries.  So long as SSN remains indexed, you should be able to use it for JOINing without a performance penalty.  

Steve Goodhall, PMP


-------------- Original message -------------- 
From: jeffrey.demulling at usbank.com 

> 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" 
> > 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" 
> > 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. 
> ============================================================================== 
> 
> -- 
> AccessD mailing list 
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd 
> Website: http://www.databaseadvisors.com