Thanks for the reply. All seems to be working well with the imported tables. I have code to work with the MM automation objects to do updates so hopefully that all still works.

Cheers

Steve

Hello All It's been a while since I worked with MM and am trying to get some music files organized. I had quite a fancy Access database that assisted with getting info for the files. Anyway, I hadn't used the Access DB in years. I had been using it with an older version of MM (not sure what version ...

I think I may have fixed it. I moved the .commit before the UpdateDB and I was able to update 120 songs without an error. If the error pops up again I will reply to this post with updates.

Steve

I am running the code below in MS Access to perform some bulk updates on some songs and I am getting the error: Error executing SQL statement "COMMIT" : SQL logic error or missing database (1, 21) It works for about 30 to 60 songs, then stops with the error above. I have tried adding a del...

Perhaps this was answered earlier, but I haven't seen it... I would like to know if I have a translation of 'Metal=%Metal%' and 'British Metal=British%Metal', will both genres get tagged if the script pulls 'British Heavy Metal'? It should hit with %Metal% as the tag contains 'Metal' but it should a...

That looks like it may be useful. Thanks!

I figured it out. The database is on a networked HTPC and I am trying to update from another PC on the network. I rescanned the HTPC C:/ drive with the network name instead of C:/ and I could update from the other PC. It created duplicate entries in the database (now it has two paths to the same fil...

I am trying this code as a test to build a script to do some mass updates in MM for me. The new Genre shows in MM on the song I want it to show on, but when I update the library, the Genre tag is reset to the previous Genre(s). Your help is greatly appreciated!! Sub TestAddGenre() Dim SDB, Iter, obj...

Actually no, it's not easier to update Genres in MM manually when you have several thousand of them. Isn't that the point of scripts? I can handle doing some manually, but not thousands. I gave up on SQL and am trying UpdateDB and WriteTags methods with no luck. I will start another thread to try to...

I am trying to get this to work with adding new Genres. I can get a new Genre to add to the Songs table, but once I rescan my library, the new genre disappears. I tried adding the new Genre to the Songs table, Genres table and the link between the song and new genre in the GenresSongs table, but sti...

I've been trying Jaikoz and it works fairly well for what I want. It's auto-tagger is a little more accurate than MusicIPTagger. it has settings that can help it pick the album was originally on. If that fails, it has a manual tag function that lists the album and year the song appeared on and you c...

I was hoping there were more functions available as the table states "The table below describes most of the commonly used characters and fields in a mask." The phrase "most of the commonly used" implies there are more - they are just not listed.

Oh, well.

Steve

Thanks for the advice, trixmoto. I think the problem may have been incompatibility between the image size selected in the drop down and the image sizes I had in the min max box. Once I changed the image size to "Large" BAF started working as I would expect. It skipped images too small/larg...

Is there a function for the file masks similar to the VB "InStr" function or the Excel "Search" or "Find" functions? Or even the SQL LIKE with wildcards (Acces SQL example - SELECT MyField FROM MyTable WHERE LIKE "*MySearchString*") A function like this for my...

Thanks for the response. I'm going to try a multi-step approach: 1. Tag album name with MusicIPTagger What it doesn't get correct, I'll try: 2. DiscogsAutoTag Anything left, I'll get with the built in Amazon lookup. I just hate typing the name of the song for the amazon lookup as it only searches (a...