Need a database

[mrmagoo_83]

I am looking for a database to organize my MP3s, Videos, and so on. Now I have tried it in Access, and because I am not that knowing of how to work Access, it failed misserably. Now what I am asking is, does anyone out there know of where I can get a free or relativly cheap already made database for this purpose; or can any of you, given the specifics I want, put together a database for me? Or help me through Access enought to fix mine.


What I am wanting is to be able to see a list of all the songs by an artist. Then sort another way and see all the artists I have that sing the same song. Other things such as Size of the MP3 and length of the song are also needed in the database.

Any help or advice would be great appreciated.:D

[bluedanube]

If you don't like Access, you can try MySQL. MySQL is small, free and pretty efficient. For windows, it has a GUI to help creating database. It is a database of choice for small to medium webservers. Its website is at:

http://www.mysql.com/

My thinking is however, with any databse, you will still need a little effort to learn it at the beginning.

[mrmagoo_83]

Thanks I will see about trying that.

[Rhino302]

I can make an Access DB for you on that within 30 minutes. If you want, PM me your email address...it's really the best way. THat way, you can possibly learn from it, and add to it.

[qball]

mrmagoo_83,

You're not thinking of storing audio/video in the DB? or just the file information (artist/album/song. movie/yr/actors, etc...)?

[mrmagoo_83]

no not the actual audio, just the info.

[qball]

good.

before you do this with a DB, one question.

how do you 'deal' with this info now?

a) spreadsheet
b) posty notes
c) in me head
d) what???

[mrmagoo_83]

The songs are in folders according to the artists. I either use Explorer to view them, or just try to remember what I have. I am wanting to do this so that if I am trying to download a song or a friend wishes to know if I have a song (not know the artist) I acn just do a search through my database and find if I have it and who sings it. Other reasons are just so I will know what all I have in a nice neat package, so I dont keep downloading the same song cause I just glanced over it.

[qball]

ok, fair enuff.

explorer will work, but the memebring is problematic.

you need to manage yo stuff better, DB won't help this.

Iffin you have songs in 'folders' by artist, then go to 'folder' that contains 'artists', invoke DOS box, type:

dir *.* /b /s > dirlist.txt

(thi does, show all files, 1 per line parsed, recurse subdirectories, into dirlist.txt)

dirlist.txt will most likely hold all data you want to encapsulate into your DB.

Now, wanna learn how to manage 'stuff'?