Edit MM.DB using Microsoft access?

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:
BBCode is ON
[img] is ON
[url] is ON
Smilies are ON
Topic review
   

Expand view Topic review: Edit MM.DB using Microsoft access?

Re: Edit MM.DB using Microsoft access?

by evanslee » Sun Jul 10, 2011 12:57 pm

You can also use this programme to view, import, export, Executer SQL query etc...

http://sourceforge.net/projects/sqlitebrowser/

What i would like to do is compare the dates contained in the MM.DB to another database I have which I know has the correct year of the song in it, and then update the MediaMonkey date based on that, rather than having to look them all up from Discogs which is limit to 5,000 per day.

Re: Edit MM.DB using Microsoft access?

by Darryl_Gittins » Tue May 26, 2009 1:53 pm

Thanks That helps a lot! I was able to use that to export the works to Excel, and from there grab what I needed.

For anyone that is curious, get the plugin from https://addons.mozilla.org/en-US/firefox/addon/5817
Drag the file onto Firefox to install it.

Cheers!

Re: Edit MM.DB using Microsoft access?

by raharris » Tue May 26, 2009 12:24 pm

I think MM uses SQLite now.

There is an add-in for Mozilla Firefox that lets you view information

I do not believe that lets you create any reports, however.

Edit MM.DB using Microsoft access?

by Darryl Gittins » Tue May 26, 2009 11:23 am

It used to be possible to edit the MediaMonkey.mdb db in Microsoft Access, but no longer can you do that with the MM.DB file. Is there another way to edit the MM.DB file directly with a program such as Access?

I'd like to get direct editing access to the database, so that I can export text lists such as the custom fields.

Thanks!!

Top