SQLiteSpy needs the RMNOCASE extension loaded. See https://sqlite4roots... SQLiteSpy.html
Worked like a charm (so far - still testing)
I had a hard time getting the RMNOCASE DLL to load. I had to turn off my anti-virus temporarily to get it to take. Then it seems to have run great.
Testing complete, worked great. That takes care of the "added by Ancestry" stuff. Now I just need to figure out how to straighten out the naming for the old media files that I loaded without a consistent naming convention. Another problem for another day. I'll set up a schedule to run this periodically to fix the new adds from Tree Share going forward.
Thanks again Tom, you have been a great help.
Tom - FYI - I have found an issue with the RMNOCASE DLL. As said before, I have to turn off my antivirus in order to get SQLiteSpy to accept the DLL. However, when you close SQLiteSpy the DLL disappears, so you have to reload each time you want to use the program. Haven't found the cause yet, so I guess that's the work around for now.