How do I open / edit a .sdb file

Question

I have a .sdb database file which I need to open. It's the database behind Song Pro (http://creationsoftware.com/).

Google seems to think that openoffice may be able to open this, as it might come from star office. But I can't persuade the file to open in Base 3.2 and there are no reliable instructions as most google results are of the extension definition type.

Initially I could do with doing this in a database browser to see how the database is laid out. But assuming it is holding the correct data I will then want to do this programmatically.

Any help much appreciated.

Thanks Jona

Solution

This page says that the SongPro .sdb file is an MSAccess database and you can just rename it to .mdb and open it with MS Access. There's also a script linked that someone has written to convert the contents of the database.