Thread: KMA headers
View Single Post
  #2  
Old August 12th, 2005, 07:41 AM
Wallymeister Wallymeister is offline
Registered User
 
Join Date: Nov 2003
Location: FLORIDA
Posts: 232
Post One way

Hello John,
One way to change the file headers is to use Update Query in Access. If you know how to use Access? Open songs.mdb and create update query to replace your drive letter say from "M:\Karaoke Songs\" to "K:\Karaoke Songs\"

This will in a click of a button replace all your listings to whatever you need, but be vewy, vewy careful here. Always back up your songs.mdb file before you try something like this, because one minor error and you will mess up a lot.

Then of course after you run the Update Query you would have to do a Rebuild Database in Hoster.

Let's see if anyone else can suggest a better way to do this first before we go any further. I am an Access programmer so this is simple for me but it is touchy if you're not careful.

P.S. You would naturally need a version of Access, preferably 97 or newer.

Wally
Let me know if you want to do this and I can step you through it or write the query for you and send it to you.
__________________
Smile, and be number 1 suspect for sure.
Reply With Quote