Deb's Pro Karaoke Player Installation  

Backing up your database

 

This can be a little tricky, if you don't understand how and where files are stored on your computer.

 First, you must locate your individual storage space. Usually, this is in the folder "Users".
Find your personal folder. It is whatever you called yourself when you set up the computer (Mine says <Bud Cranford>).  Open that folder.

You will probably have to set your permissions (folder options) to show hidden files.
For Windows 7 click "Organize" in the menu bar on the upper left.
Click "Folder Options".

This will open a Window with three tabs.
Select the middle tab "View".

"Hide hidden files, folders and Drives" is probably checked. Click the button below it to select "Show Hidden Files, folders and Drives".
I also find it more sensible to uncheck the 2nd section below that, ""Hide extensions for known file types".

After this, select "Apply to Folders" then OK" and close the window.

Now you're ready to back up the Database.

In your User files you will now see a folder named "APP Data".  Open this.
Inside will be several file folders, including "Roaming".  Open this folder.
You should see a file folder named "Deb's Pro Karaoke Player".  Open it.
Inside Deb's folder you will find two files called kPlayer.mdb and another called kPlayer-backup.mdb
Copy these files to another location, preferably a Zip Drive, Thumb Drive, Flash Drive, or whatever you call it.
An external hard drive works, as well.  Maybe even the one your music is stored on?

By saving these files to a safe location, you can reinstall them in the event of a computer crash.
Even if you are forced to get a new computer, you can load these files to the appropriate folder and PRESTO. Your singer history and venues are restored.
Be sure to update this information every month or so, to make sure you have the latest version of the database.

The database files can be edited in Microsoft Access, if necessary.
For example, you may get a new external hard drive, that installs to a different drive letter than your previous one.
I'm not going to explain that process, as you must be familiar with Access to do this properly.
I prefer to set the Drive to the same path as the Database

If you have purchased a new external hard drive you may find that the database is working properly. You can see your Venues and Singer History, but when you try to play the music it is "Not Found".
This means that the new drive was assigned a volume letter that is different than the drive letter, when the database was created.

The database lists the drive and folder where it expects to find a particular file, such as <E:\Karaoke\Goodnight, Sweetheart - Spaniels>.
If your new external drive is now F-Drive, the database will tell you it cannot find the file (in that location).
The database will NOT search until it finds the correct file. It will only look in E-Drive.
The only solution will be to reassign the new storage device drive letter, to what the database is listing.

>
Changing your Drive Path

To change your drive letter, you must go to the Control Panel and find "Administrative Tools".
Open the "Control Panel" (Windows 7) or "Settings (Windows 10).
I'm not going to describe the process for that gawd-awful Windows 8.  If you're still using it, get a new computer.

If you don't see "Administrative Tools" type the name in the search box in the upper right of the window. That should locate the file.

Select "Computer Management" then "Storage" then "Disk Management".

You will get a window that looks something like this.

Select the drive letter you want to change (Your external drive) then RIGHT click it and select "Change Drive letter and Paths".
(The Computer I'm using to demonstrate this procedure is running Windows 7, and I do not have an external drive installed.)
When you right click and select "Change Drive Letter and Paths" you will get another pop-up windows that looks like this.

Typically, the first external drive you plug in will be Drive-E.
("C" is your main drive or operating System.  "D" is normally your CD-Rom.)

If I wanted to change the drive in the picture to "G"-Drive, click the button labeled "Change", then type the drive letter you want it to be.
Then click "OK" and the window should close.
You'll probably have to restart the computer so the changes can take place.
If you have done these steps correctly your external drive is now set to the same drive as your database and can access the appropriate songs.

Recently I have seen computers that contained a "Recovery Volume" as a Hidden partition.
This is used to restore your computer to its original state, but without the necessity of supplying a CD or DVD with the Windows program installation
This can be a problem as now the computer has;
C-Drive as the operating system.
D-Drive is the Recovery Volume
E-Drive is the CD or DVD ROM.
Letters are assigned as new storage devices or partitions are added; the next device installed will automatically be assigned the next available letter.

Chances are, if you used Deb's Karaoke Player on a computer without the recovery volume your external storage device was designated as E-Drive, but that drive is no longer available. E-Drive is now assigned to the CD/DVD ROM.

If you encounter this, it is correctable without requiring reassigning the database with MS Excel.

Make sure no other removable storage devices are plugged in.
Go into Windows Disk Management feature and assign the CD/DVD ROM to F-drive. This will harm the computer.
Once you have reassigned the DC/DVD ROM, you can reassign the external storage device to E-Drive where the database thinks it will find your music files.
NOTE: This may require a couple of restarts to reassign the drives in your registry.

 

Which Drive Do I Need?
If you do not know which drive the database is referencing, you could open the database manually, if you have Microsoft Access on your computer.
Go to the saved database. Not the original (just in case).
Double click on the file and it should open with Access.
On the upper Left s you should see four Categories Karaoke_Tracks - Marked_TracksSinger_History and Tracks.
Right Click on Singer _History then select “Open” and read the line. (You might have to open it wider with the slider at the top of the column).
Look for a single letter, followed by a colon as in E:\
That tells you where the database is looking for the file. Close the database.
If it asks if you want to save the changes, select NO.
Rather than edit every line in the database, use Disk Management tool to set your external drive to that letter.

You could, as a last resort, edit the database using the Find/Replace control, but I really don’t recommend this.
It’s easy to mess up and destroy the path to the files.
Once you assign the correct letter to the external hard drive, restart the computer. Your database should now be able to locate the proper files.

 

 

A couple of other tricks I have learned.

When you are doing a show, you might be given a song file that you didn't have, previously.
I have taken a song file from my collection that the other KJ's didn't have, and put it on a thumb drive, to add to their collection.
Outside of Deb's, Drag and Drop this file from the thumb drive, into your storage folder.
To add this selection to Deb's, so you can play it immediately, locate the file in your storage folder, then drag it into Deb's playlist window, even if another performer is singing.
It will add that song to the current playlist, though it is not even in your Database.
You can double-click on the blank Name space, to add the performer's name, so it will be saved in their history.
When you update the database, the song will become discoverable through Deb's Search feature.
While I'm on that subject, "Create Database" will delete, then re-write the entire database.
"Update Database" will leave the original database intact but add any new files it finds.

PITCH

Occasionally a singer will ask you to adjust the Pitch (key) of the song, while they are singing.
Of course you can adjust this using Deb's interface, but this will not save the changes. The next time they ask for the song, it will revert to the original key.
If you go to the selection they are singing in the playlist window, and Double-Click on their Name, it will bring up the song settings, without interfering with the playback.
(NOTE: If you accidentally click on the song title, it will play that song.)
From here, you can also make changes to the pitch. Bring it up or down, as necessary.
REMEMBER: Deb's adjusts in 1/2 note increments. Two clicks will change the song by one full note.
When you close the window the changes are a permanent part of their history.
The next time they ask for this song, it will be in the lower or higher key.

TEMPO

Even more rarely. the singer will say the song is too slow or too fast.
In the "Pacemaker interface you can adjust the speed, Tempo, or both.
Make sure the "Pacemaker" window is open. You should see three controls. TEMPO - PITCH - SPEED.
TEMPO with make the song slower or faster without effecting the Key or Pitch of the music.
PITCH with raise or lower the key or Pitch of the music.
SPEED will adjust the speed of the music and raise or lower the pitch, equally. (I can't imagine needing this).
TEMPO and SPEED increase the speed of the song by per-centages, while PITCH will change the key of the music in 1/2 note intervals.
Personally, I would use the Pacemaker interface only for speeding up or slowing the song by adjusting the TEMPO control.

That's some pretty advanced stuff, isn't it?
I guess that's why they pay me the big-bucks; to know how to do all of this.

If you follow my direction and find any errors or unclear instructions, Please let me know, at
  Bud's Email  

 

 

I hope this makes your installation simpler and easier.

 

Do you want to visit my Karaoke page?
Pictures of many of our singers and a lot of the songs I try to perform?

Buds Karaoke Page