I think I may be over the hurdle on this.

Digging deep down into the SQL Network Configuration, I noticed that Named Pipes was not enabled. Once I enabled this, I got a different error when I launched the Access front end (a logon timeout) but then I clicked OK at the logon prompt and voila...up and running. After that initial timeout, all subsequent times I launched the Access front, it started with no errors.