On Fri, 21 Aug 2009 17:34:09 -0400, SgtBob <s...@cox.net> wrote: >Dennis et al - I don't know how to make it any plainer - I want to change the >File Detail ID number from 1234-1 to 9876-01. I would like to use Access to >enter 9876-01 in lieu of 12340-1 in the 'File Ref' field or whichever table >this will work on. I woiuykld liek to do it this way so I can see if I >covered all of the changes I need to make. My attempt to change it by opening >one of my saved .fdb files in Access, then using the tblSX, making the changes >and then when I exited Access and opened the .fdb file, the changes did not >occur - so..... If this explanation doesn't cover it, I'll move on.
Just another thought... Have you looked at doing this in Legacy with Search & Replace? It will do the same thing and you won't have to deal with SQL. -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp