Access Linked Server error "The provider did not give any information about the error."
I found the issue but I'm not sure why its happening.  

To query the linked server I have to right click SSMS and select Run as Admin.  Then I can query the access db.  

I dont know why this is the case as I'm remoted into the machine.  I'm an administrator on the machine.  I created the Linked Server to the Access Database which resides on the C:\Drive of the server.

But this will at least allow me to hand run my code.  Since this is my development server I think that will suffice at least for now.