Click here to Skip to main content
11,493,948 members (69,641 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-CE
I am developing a small windows form with sqlCE. i made an installer to deploy it to another machine. I added the MyDB,sdf to the Application Folder. but when i run the application it gives me following error.

Access to the database file is not allowed. [ File name = MyDB.sdf ]

i checked the folder in program file(86) and it contain the .sdf file but can't figure it out what is the problem.

my connection string is string ConString = @"Data Source=MyDB.sdf";

any idea what i am doing wrong?
Posted 9-Aug-12 19:57pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

"Program Files" in Windows is protected, so normal users cannot write there, your applications will probably work with an administrator user.

Change the data folder path for your database to somewhere where all users have permission to write.
SR.Rizwan at 10-Aug-12 2:50am
how can i change the folder and specify it in the installer?
Mehdi Gholam at 10-Aug-12 3:08am
Consult your installer documentation, for your code make the database path a configuration point (instead of hard coding).

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 448
1 Nakul Chaudhari 240
2 OriginalGriff 225
3 F-ES Sitecore 219
4 CPallini 215
0 Sergey Alexandrovich Kryukov 10,237
1 OriginalGriff 8,730
2 Sascha Lefèvre 3,664
3 Maciej Los 3,392
4 Richard Deeming 2,500

Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 10 Aug 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100