Symptoms: I pull up the "Duplicate Titles" view in "Files To Edit" node. I select a number of songs to delete and click he Delete button on my keyboard. I choose "Delete from Library and File System" option. The deletions proceed and the deleted titles disappear from the view. But some seconds afterward (usually 3-5 seconds), I get an error dialog with this text:
There was following problem with querying database:
40000:[Microsoft][ODBC Microsoft Access Driver]Syntax error
(missing operator) in query expression 'UCASE(LEFT(SongPath,
95)) = UCASE(':\MP3Library\SongTitle.mp3') AND IdMedia=44.
I get Cancel/Retry/Ignore buttons. Cancel and Ignore clear the error. Retry never has. It doesn't happen every time I delete duplicates, but when it does happen, that's where it happens. I might get several of these for a block of duplicates deleted and each one that comes up stops me from doing anything else until it's cleared.
ENV: WinXP w/SP3 on a P3650 w/ 256MB PC133SDRAM. My Access installation is Office XP Developer install.
Intermittent ODBC Error After Deleting Duplicates
Moderator: Gurus
That's interesting, could you please generate a debug log of this error so that I can see the whole context of the problem (see http://www.songs-db.com/forum/viewtopic.php?t=69 for a description of how to do it). Send it to my e-mail then, please.
Thanks,
Jiri
Thanks,
Jiri