EXCEL 365 VBA & SQLSERVER COMPACT..."Provider cannot be found..."

[necalabria]

Hello budies,

My first time dealing with SQL Server Compact and Excel 365 VBA.

I referenced to:
Microsoft ActiveX Data Objects 6.1 Library.
Microsoft ADO Ext.6.0 for DDL and Security

I connected to the DB using:

The app is doing great in the desktop I used to coded it, same computer that has SQL Server Management Studio installed.

The problem is when I try to used the app in another computer, I receive an error saying "Provider cannot be found..."

The app is going to be used in many labtops that have not SQL Server installed.

I appreciate any help to solve this issue.

Thank you so much

Nelson

[mjr veverka]

Did you check here ?

https://www.connectionstrings.com/sql-server-compact/