[sevekj]

I have been able to edit anyway I want any data I want and create the hoster books anyway I want, here is how.

First and most important. Make a copy, make a copy, make a copy!!!! Use a CD or another hard drive or copy and paste to desktop, whatever you feel safer with.


I open MS Access, find the database named "songs"

Open the Table "songs"

The songs info for all the songs you have imported should be displayed with columns for all the data necessary for hoster to work properly.

You can edit anything in this database, do not mess with the path column you will be very sorry!!!!, Only edit title and artist as is necessary for misspellings and other like problems.

Replace the original "songs" with the edited one and you are done. Make a copy of the edited one if all works fine and then discard the old backup.

Also, If there is data you do not want to appear in the books such as the mfg# you can make an edited copy, with mfg# column removed for example, place it temporarily in the database folder, place the original on the desktop or be sure it is saved in it's original condition on a CD or HD, open Hoster, select the books tab and prepare books. Close Hoster, reopen the hoster database folder find and open the word file you want, title or artist, , edit Header/ Footer, print , replace the original "songs.mdb." in to the database folder so that the info will display in hoster and so hoster will work properly, do not forget to do the last step,and you are done!!!

And don't forget, backup, backup, backup!!!! Very important!!!!

Proud hoster user, Seve