On 2011/09/20 14:36, Dennis M. Kowallek wrote: > On Tue, 20 Sep 2011 07:57:14 -0400, Dennis M. Kowallek > <[email protected]> wrote: > >> You might be able to write an SQL UPDATE query that will change all >> .jpe's to .jpg's in tblBR. But it won't touch the file system. > > To change all .jpe's to .jpg's in tblBR: > > UPDATE tblBR SET tblBR.PicName = > Left([tblBR].[PicName],Len([tblBR].[PicName])-4)& ".jpg" > WHERE tblBR.PicName Like "*.jpe" > > Now all you have to go is rename them in the file system. > > The usual warnings apply.
And this one! What happens when the extension is .TIFF? :-) -- Regards, Mike Fry Johannesburg Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
