I take it since this is posted in the MSAccess forum, you're looking for an MSAccess solution.
Here's a program I made to help me with a bunch of Word, Excel, and other MSAccess files on a specific drive. The goal was to create some kind of menu system where a user could quickly search for and find a specific file on the drive and then click on it and launch it. The table can be repopulated for pdf files if you think this program will help any. Of course you'd probably want to change the looks.
But this requires MSAccess to be installed on the user's computer, you might be looking for visual basic code where you can create a .exe program which doesn't require MSAccess (that's why I'm wondering why this is posted in the MSAccess forum.)
Note: Use the shift key when opening the mdb file as I use some code to get rid of the MSAccess information when the Public Health Main Menu form opens. This way only the form opens and it doesn't look like it's an access application. If you want to try it, repopoulate the table via the PopulateTable form.
As far as the auto-running for the cd, you need to create an Autorun.inf file to put on the cd which automatically launches whatever menu you might have. Research Autorun.inf on specifics to do this.
You might then want to create one cd with all your pdf files, create your menu system pointing to all the cd files (possibly using the UNC path), and then use that Menu with the 2nd cd you create also with the pdf files and the Autorun.inf file. To me it almost sounds like you want to create a pdf "Menu" to launch the other pdf files which you would create as a pdf file.
Again, I'm not sure if this is what you're looking for but I thought I'd send it anyway.