Quote:
Originally Posted by bugspappaw
I upgraded to 4.32 and my singer/song datbase is not working properly. WHen I pull up a singer, I get the singer but sometimes I don't get their songs. I get someone else's songs under their name. I have to hit enter several times to get it to re-index. SOmetimes it does sometimes it doesnt. Also, sometimes when I add a new song to their database, it puts their name out twice in the list. It eventually corrects itself and shows just one name. It seems the index problem happens about half-way through the singer search. I have looked at the Access databases and the ratio of songs to singer and id's to singer look correct. I did have problems in the past from where I had deleted singers and songs and had to manually adjust them in ACCESS, but they look ok. Is there anyway to reindex the database without totally wiping it out and readding the singers and songs manually? This problem just compounds the slowness of the song returns for my singers. THanks.
|
From your previous posts and now this it sounds like your singer's database is still corrupted. You may have caused that by making changes in Access. Hoster uses the older format for Access from Access 97 and if you have made adjustment/changes in a newer version then this can cause problems.
There is no way to re-index it like you can do with the Songs database. So manually re-entering them may be the only way to do it. The way I would do this is to rename the existing file so Hoster doesn't see it. Then open the renamed db in Access and use it to guide you through re-entering the data in Hoster.