I have an Access ADP which connects to a SQL server.

When I open the project from a shortcut on a different IIS server it opens fine, retrieves data etc.. works fine. ( I can edit do what ever I need to)

However, If I try to open the file directly from my machine it receive the data provider could not be initialized error.

I have verified that the connection data link properties work (test returns a test connection succeeded).

Help, totallay baffled... Any ideas?