For the edumacation of those as ignorant as I....

The answer is in the following line of code:

lcConnectionString = "DBQ=" + JUSTPATH(lcPIRPath) + CHR(0) + ;
		     "DefaultDir=" + JUSTPATH(lcPIRPath) + CHR(0) + ;
		     "DSN=PIR" + CHR(0) + ;
		     "Description=PIR Report Table DSN" + CHR(0)

With the key being the "DSN=PIR" line. Ya gotta give the animal a name folks, and then it works as advertised. Thanks for the class Mark; it works really well when you feed it the right meat.