Connecting to SQL CE Files (.SDF format)

[GBalcom]

Has anyone had any luck connecting to these databases? Our Engineering software creates them for each work order it produces, and I'd like to pull information out of them. It's an MS SQL Compact edition file. I would likely prefer to connect via VBA, as the connection will be dynamic in my code. (The code will know which db to connect to based on prior logic.)

 

[Uncle Gizmo]

I found this Link:- VBA Access to SQL CE 3.5 Returns Error

And This Blog:- Everything SQL Server Compact