Sounds like it's running from a non trusted location. Is the folder trusted that the ACCDE is in?

Hello Adam,

It originally was not in a trusted location and I thought that was the problem. However it is now in a trusted location and the problem persists.

Thanks Joe

To the bast of my knowledge the file links have to be correct when you make the  ACCDE.  
You can't re-link after making the ACCDE file.

I'll throw this in here Troubleshooter see if it has anything that helps.

I think he's referring to the VBA button on the form that's made that links to the SQL tables here, which should still work as long as it works in the ACCDB.

If you run down the troubleshooter and still have problems, maybe try to re-make the ACCDE in the trusted folder and try it. Or make a blank ACCDE with just a messagebox button in it, see if it can run in that folder. I'm almost certain that's your issue if all of your front end VBA is broken.

Yeah, my relink tables button should work even in the ACCDE. Obviously your code compiles or else it wouldn't create the ACCDE. I'm stumped. Can't think of any reason why it would work fine as an ACCDB but not a DE.