SongDatabase Editting

[marklwood]

Originally Posted by dbeland50

Yo Douglas, tried your suggstion...didn't work for me. I did in fact do an Access update, only because I know how to use it (not evrybody can, which is understood). Another example of nomenclatures not updating is the group "Shedaisy". Reference file shows it as "SheDaisy". There's got to be a way of correcting the reference file because even if you try to type in the corrct spelling, it won't let me. Hmmm...weird.

This is part of a learning process for MTU. When I say learning, I'm talking about the 2 way communication with the songs.mdb. This is a new process, and I'm sure it will take quite some time to get it all straight.

I noticed also that this also happens in the singers database entries. If you typed the wrong capitalization the first time, you can't correct it without removing the entry.

[ddouglass]

I did about 20 songs in the Edit Songs tool this afternoon when you brought it up, so I know it works. Did you try doing it with the Automatic-fill unchecked? I did mine with it checked but Marklwood suggested turning it off and I know that works too.
All I did was to do a search (with Artist turned on) for Dwight in the Edit Songs tool. Then highlight the first one and right click in the Artist block below the list. Wait a couple seconds (for the automatic fill list to complete) and type in the corrected name. For the rest I highlight the name again and Press Control C (for copy) then select the next song right click on the Artist again and press Control V to paste the new name in. Works like a charm.
By changing them in Access, the next time you have to Rebuild or Add Database all those changes will revert back to what is in the KMA header which doesn't get changed from Access.

[Joe Nieves]

Originally Posted by ddouglass

I did about 20 songs in the Edit Songs tool this afternoon when you brought it up, so I know it works. Did you try doing it with the Automatic-fill unchecked? I did mine with it checked but Marklwood suggested turning it off and I know that works too.
All I did was to do a search (with Artist turned on) for Dwight in the Edit Songs tool. Then highlight the first one and right click in the Artist block below the list. Wait a couple seconds (for the automatic fill list to complete) and type in the corrected name. For the rest I highlight the name again and Press Control C (for copy) then select the next song right click on the Artist again and press Control V to paste the new name in. Works like a charm.
By changing them in Access, the next time you have to Rebuild or Add Database all those changes will revert back to what is in the KMA header which doesn't get changed from Access.

Hi ddouglass

Yes you can edit and then write changes back to the header without loosing the changes you made in the database, But you gotta know what you do.

Joe....

[ddouglass]

You will have to tell me how you can write to the header in the KMA file? And don't tell me with a binary editor because 99.5% of the people here wouldn't know what one was or how to use it.I know there is know way within Hoster except to use the Edit Songs utility.