[nreel]

Q1. Yes, this is an MSAccess Database. MDB is from an MSAccess Database.
You are looking for SONGS.MDB

If you cannot see the extension "MDB" then do this: (assuming you have WinXP)
Open MY COMPUTER

Click on TOOLS at the top

Click on FOLDER OPTIONS at the Bottom of the TOOLS Menu

Click on the VIEW Tab in the FOLDER OPTIONS Menu

Under FILES and FOLDERS, make sure all Boxes are "CHECKED" but the box next to the one that says "Do Not Cache Thumbnails."

Under HIDDEN FILES and FOLDERS, make sure the RADIO BUTTON on "Show Hidden Files and Folders" is selected. Make sure all Boxes are "CHECKED" except the FOUR boxes next to the ones that say "Hide Extensions For Known File Types," "Hide Protected Operating System Files," "Restore previous Folder Windows at login," and "Show Control Panel in My Computer."

Click APPLY
Click OK

Now you should be able to see all extensions on all files.

The, original, Songs.MDB, prior to Hard Drive Failure, is what you are looking for and trying to save.

Q2. I have MSAccess Software, so I don't know if you will be able to OPEN the SOngs.MDB if you do not have MSAccess.
Once you locate the Songs.MDB, double-click the file and see if it Opens. If it does Open, then you can read the file.

Q3. Correct
Info about Brand/Disc#/Track#/BookID#
If you can Open the files, you can Print them.

Q4. Alpha Sort, meaning, "to put in order," however that order is.
First, I would Alpha sort the Book ID column so that an accounting of all Book Ids will be at a ready reference and Print the Data.

This gets tricky Alpha Sorting this column because there are no leading ZEROS on BOOK ID 1, which is where MTU didn't see the wisdom in adding Leading ZEROS - which, as you can see, is needed for just this purpose - Alpha Sorting, and you will end up with this kind of Sort:
101
10101
Obviously, 10101 (ten thousand one hundred and one DOESN'T come after one hundred and one...does it? I mean, there are a lot of Book Ids between 1 and 101 that will not Alpha Sort where they should be due to the lack of leading ZEROS.)
With 3 Leading Zeros: (This accounts for 9,999 discs, which we will never see in our lifetime.)
000101
000102
etc.
010101
Which, an alpha sort would be 100% meaningful on the Book ID column.
But, suffice to say, most of the Book IDs will be in order.

Unless you know how to REPLACE text...Then, you can add 3 ZEROs in front of all numbers beginning with 1 through 9 and Two ZEROs in front of 10 thru 99 and One ZERO in from of 100 thru 999 so that all Book IDs will have the same number of Place Holdings for true Alpha Sorting. This is very complicated, though.

Then, I would Alpha Sort on the Disc# and Track#. Go through Disc by Disc and separate what I have from what I don't have.

Once separation is accomplished, I would use the OLD Songs.MDB to determine, on a disc by disc basis, what Book IDs belong to the remaining and unaccounted for discs and Re-import those discs using the, now, known and previous assigned Book ID.

The saved SongBook file may help, somewhat, but, Book Ids without Disc Numbers may be worthless. Even, assuming you had your SongBook print the Disc Id info, the Disc IDs are not in columns by themselves in order to perform an Alpha SORT.

Basically, it may become an added reference for checks and balances.

Q5.Fortunately, when the database is rebuilt with what you have salvaged, all the editing, previously done to the KMA Header, will be restored.

Unfortunately, any disc that needs to be re-imported will only go by the data pulled from the BUCKET.MDB. However, the silver lining is that, with the Original SONGS.MDB, you can compare, line-by-line, info of how its Artist/Song Title info was to the Song info you are getting ready to Import and make changes accordingly.

I know that this is a lot of info, but approaching the problem in a systematic way will help ease the burden.

If you need help in manipulating your Songs.MDB PM (Private Message) me your email and I will help as much as I can. I could probably tell you, in about 3-hours, what is missing and what Book Ids belong to what is missing.

Norm

For those of you, other than Nitecat, who may read this POST but do not have the ability to understand what I am offering, in the way of help, I will spell it out.

I am not asking Nitecat to send me ANY KMA files. I am only offering assistance with his MSAccess Database.