I am using SQL Server CE 4.0 SP1. I am using Web Developer 2010 Express to connect to database and perform operations like creating table, modifying column etc. But we cannot connect a database in a network share which is not allowed.
I tried with the SQL Server CE Toolbox and Visual Studio add-in these tools allow us to access database present in network path but does not allows us to edit columns directly. It only creates script which we need to run again. So it's not a simple tool.
Is there any other tool which allows us to directly edit columns and perform all database operation for the database (
.sdf) in network share ?