by skj88 » Fri Dec 21, 2018 5:40 pm
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 it was, may been 3.X). Everything worked beautifully back then. But that was several years ago.
Anyways, using MM 4.1.21.1875 now and I was working on hooking up my Access DB to the SQLite Database via ODBC and was getting the "No Collation Sequence" errors when I was trying to import the SQLite tables into Access tables. Couldn't find any workarounds. But I did figure out something that does work that I didn't see anyone else mention. The "No Collation Errors" only happens on Linked tables. If I import them, everything imports fine. Characters in artist names appear to be fine (i.e. Motörhead). Also imported Chinese characters correctly into the Access tables.
This seemed too easy of a workaround so I'm worried there might be an issue that I am unaware of by importing as opposed to linking. I'm hoping someone more knowledgeable about the unique collation in MM can comment regarding any concerns accessing the MM tables this way.
Thanks,
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 it was, may been 3.X). Everything worked beautifully back then. But that was several years ago.
Anyways, using MM 4.1.21.1875 now and I was working on hooking up my Access DB to the SQLite Database via ODBC and was getting the "No Collation Sequence" errors when I was trying to import the SQLite tables into Access tables. Couldn't find any workarounds. But I did figure out something that does work that I didn't see anyone else mention. The "No Collation Errors" only happens on Linked tables. If I import them, everything imports fine. Characters in artist names appear to be fine (i.e. Motörhead). Also imported Chinese characters correctly into the Access tables.
This seemed too easy of a workaround so I'm worried there might be an issue that I am unaware of by importing as opposed to linking. I'm hoping someone more knowledgeable about the unique collation in MM can comment regarding any concerns accessing the MM tables this way.
Thanks,
Steve