Provider cannot be found error

[CamiWami]

I am trying to use use VBA to sync data to and from excel. When I try to sync from the database I get "Run-Time error 3706 Provider cannot be found. It may not be properly installed." I'm not sure what this error means. I've looked online for solutions and have just further confused myself. I'm not sure if I need to change my VBA or what.

Here is the code I'm using:

Please Login or Register  to view this content.

The error is occurring in the obj.Connection.Open section of the VBA. If any one can please help I would be so thankful!

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[CamiWami]

sorry about the I had it as a quote. I apologize.