VB.net 2010,Windows Desktop Excel ADODB Provider cannot be found

QuickBooksDev2

New Member
Joined
Dec 30, 2013
Messages
4
Hi,

We have a VB.2010 32 bit Windows Desktop program that has been running for years. It uses an Excel (2010 in this case) database which is accessed through a connectionless OLEDB connection string as
Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE='L:\accnt\CustomerFiles\DATABASE 2015.xlsm'; Extended Properties="Excel 12.0 Xml;HDR=YES"

Normally it works fine but on some systems we get a
3706 Provider cannot be found.

It has failed and worked on different W2012R2 systems. It also has failed on Windows 8.1 (64b).

On W8.1 have tried installing AccessDataEngine_x64 but it did not help (32 bit version would not install).

Can anyone help?
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

ChrisM

Well-known Member
Joined
Jun 11, 2002
Messages
2,129
Do you still have users on Excel 2003 or earlier? Don't think they'll have the ACE 12 provider.

Is everyone mapped correctly to your L: drive? Maybe some users have an additional subfolder mapped in to their L:
 

Watch MrExcel Video

Forum statistics

Threads
1,123,505
Messages
5,602,063
Members
414,498
Latest member
jordanmiller7890

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top