*So* frustrating... (geek whinge/cry for help)

[taimatsu]

I am putting together a MS Access database to function as a high-tech searcheable songbook. It's all laid out and working well. I have assorted fields and checkboxes at the top, and then the song title and so on, and then a field, obviously, for the song lyrics. I can't put these in as text or memo fields because the length for those is too restrictive. I have, therefore, a lot of plain text documents with the lyrics in, in a separate folder, and I want to apply these to the database. I thought I had it taped, because dragging-and-dropping adds them in as OLE bound objects (stored in the database file). That's fine. I'd also be happy to do them as linked docs, hyperlinks, whatever.

However, it has just fallen apart. I have *two* versions of 'The Dawning of the Day', and I want to record both using separate text files. I just cannot work out how to do this. An OLE Object field will only take one object. AFAICT, a hyperlink field will only take one hyperlink. Text fields won't do any of this stuff. I'm stuck! Anyone got any ideas?

Comments

[chrisvenus]

I'd just have two rows, one for "The Dawning of the Day (normal)" and one for "The Dawning of the Day (Smut filk)" or something like that. Treat them as different songs and I'm sure it'll be fine. :)

[danfossydan.livejournal.com]

Either do that! Or merge the two text files together - so that the first version follows on from the seccond version in the same text file.

Then you just have one entry.

[taimatsu]

I really do want to keep the separate text files, so I can (for example) just print out the one I use most of the time, and have the other version for reference.

[danfossydan.livejournal.com]

Then having "The Song I love" And "The Song I love (alternate version 1)" Is I think the easiest solution.

[taimatsu]

Sadly traditional song doesn't work like that. These really genuinely are two different versions of the same song. I can't designate them with any particular extra 'name'. Whatever fudge solution I come up with is bound not to work for the next time this happens, so I might as well fix it properly.