I have created a macro that will run an access database query and copy the results into Excel. It runs fairly well except on one PC where it gives me a:
"Run-time error '3706' Provider cannot be found. It may not be properly installed."
The error occurs in this particular line of code:
' Open connection to the database
cnt.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
I'm not sure if I have to change the version of the provider and if this is case how does one go about doing so.
Thank you Help Me Obi Wan Kenobi, You're My Only Hope.
"Run-time error '3706' Provider cannot be found. It may not be properly installed."
The error occurs in this particular line of code:
' Open connection to the database
cnt.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
I'm not sure if I have to change the version of the provider and if this is case how does one go about doing so.
Thank you Help Me Obi Wan Kenobi, You're My Only Hope.
