SQL Compact Edition 3.5 - Access to the database file is not allowed

Question

Windows 7, Visual Studio 2010, .NET 4 Client Profile

I developed an application (100% local, no access to servers) using SQL CE 3.5, it works fine on my computer. However, when i deployed it on another computer, it shows this error:

Access to the database file is not allowed. [ File name = data\BDApepucCE.sdf ]

I deployed on a windows XP computer, it shows this error whenever i try to write on the database, however, it works when i read.

I did a test on a windows 7 computer, and it worked 100%, except when the file was accessed through the homegroup (i.e local network), on which it failed on both read/write.

Thanks for your help.

Answer 1

Here are a two other suggestions:

• Try to run your Visual Studio as administrator
• Check if the 'readonly' attribute is set on the sdf file