View Single Post
  #4  
Old August 27th, 2004, 07:26 AM
nreel nreel is offline
Honor Roll
 
Join Date: Dec 2002
Location: Indy
Posts: 778
Re: song database standard "trick" need bucket password.

Since Hoster does not have the LATEST Karaoke Disc listings, I feel compelled to try and help those who have inquired concerning full access to a Karaoke Database. I can offer this:

If you want a complete Database, you can do this, if you have MsAccess and KJPro...I did and it works great.

Obtain MsAccess and the KJPro Program (226,818 total Records as of August 2004) and do this:

Open KJPro to MAIN SCREEN

Click on "VIEW/FILTER SONGS" in the "Master Song Database" Section

Click on the 1st Song's Gray Box located in the LEFT Margin (Box Turns Black)

Click and HOLD the LEFT Mouse Button on the VERTICAL Scroll Bar on the RIGHT Margin.

With the LEFT Mouse Button held continuously, Pull your Mouse Down...note Counter as you Drag...until the Counter says 55,000 or so, but not more than 60,000.

Let go of Mouse Button.

Hold SHIFT key DOWN.

While Holding SHIFT Key DOWN, Click on the Gray Box in the LEFT Column next to any SONG you wish that is displayed (This Selects all the Records from #1 to #xx,xxx - You CANNOT copy more than 60,000 Records to the Windows Clipboard - That is why you will stop somewhere prior to 60,000, each pass, until you get all the Records).

Left Click your Mouse on top of the Last BLACK Box in the LEFT Column and Click on COPY in the Drop Down Box (You are ready to Paste into MsAccess).

Open MsAccess, if you have not already done so, to a NEW Database and assign a name like KJPro.

When Database opens, click on "Create table by entering data."

Click on the Asterisk located in the LEFT Margin at the bottom of the "Generic" Table.

Left Click on the Black Line and select Paste in the Drop Down Box.

Repeat until all Records have been Cut and Pasted.

Save the Table with a name like KJPro.

You are done...sort the data any way you like.

Norm
Reply With Quote