Mark, [Not sure you got the PM I sent a few days ago]: I added a hack for converting .wma and other tracks that iTunes doesn't like. I added code to trap errors when trying to add a track to iTunes. It adds these tracks to a MM playlist called 000-itunes-to-convert. Then, you convert all the tracks ...

Mark, The script fails in copyPlaylist() at 'Set os = p2.AddFile(p1.tracks.item(j).path)' if processing a .wma file. Other non-iPhone playable files will probably also fail. For a hack to skip .wma files, add if/end if statements: if not right(p1.tracks.item(j).path, 4) = ".wma" then Set os = p2 ...

Bex,

I narrowed the error down to this piece of the query: It works ok if I remove any one of the three fields, e.g., : I have no idea why.

Bex,

It is the first time I've tried your script.

As far as I can tell, I'm running the latest WSH 5.7 and MDAC 2.8 for XP.

Hi, I got a SQL error with v2.6 and MM 2.5.5.998. There was a problem querying the database: HY000:[Microsoft][ODBC Microsoft Access Driver] Reserved error (l), there is no message for this error. Error #-2147418113 - SongsDB.SDBatabase HY000:[Microsoft][ODBC Microsoft Access Driver] Reserved error ...