Disc ID question

[gd123]

Performing a search for SC8148 will list, in numeric BOOK ID order, Trks 01-15.

I know this doesn't get you what you want, which would be to enter SC8148-01 and only have a listing of just that.

But, the technical reason is that the DiscID in and of itself does not contain a Track Number. It's a kin to the BookID ROOT. The BookID ROOT doesn't contain a Track Number. Hence, in reality, the DiscID should be technically referred to as a DiscID ROOT.

But, if logic is to follow, one can search on a BookID, which contains the BookID ROOT and a Track Number. So, why can't one search for a DiskID, which contains the DiscID ROOT and a Track Number?

Well, one glaring reason is found in the Songs.MDB...the Bible to Hoster. Notice that the BookID (not Bookid ROOT) is shown in its own column, whereas, the DiscID (ROOT) is in its own Column and the corresponding Track Number is in a SEPARATE Column.

Which is more strange because, in the KMA Songs Folder, the DiscID (ROOT) and its corresponding Track number are together separated by a DASH...not a Column.

However, I was able to convert the Access97 Songs.MDB to Access2007. From there I was able to Delete the DiskID Field, Insert and COPY the PATH Field, which had to be RENAMED to the DiskID Field, as there was already a PATH Field.

Then, I used REPLACE to get rid of the PATH info and the .KMA info, which left the DiskID-Track Number.

Then, I converted the Access2007 Songs.ACCDB back down to an Access2000 Songs.MDB. I attempted to match the "Original" DiskID "FIELD SIZE" of 16, but Access wanted to delete too much info in the DiskID Field so I left the DiskID Field at the Copied parameters of the PATH Field, which was 255.

Copied the altered Songs.MDB to the Hoster\Database Folder and Hoster Opened perfectly.

Upon performing a Search for DiskID SC8148, the Disk listed all Tracks.

Upon performing a Search for DiskID (ROOT) and Track Number 1, which would be SC8148-1, I got a truncated list of all DiskID (ROOT) Trks:
01
10
11
12
13
14
15

as I couldn't get specific to Track 01 as the DiskID is listed as SC8148-1 and NOT SC8148-01

So, if I wanted to further alter the Songs.MDB by adding leading ZEROS to single digit Tracks, I could perform an exact SEARCH, which is what you are tyring to accomplish.

Man I'm smart.