Click here to Skip to main content
11,583,859 members (60,782 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 18: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 OriginalGriff 440
1 Sergey Alexandrovich Kryukov 310
2 virusstorm 268
3 Richard Deeming 220
4 Dave Kreskowiak 200
0 OriginalGriff 1,623
1 Sergey Alexandrovich Kryukov 1,135
2 Abhinav S 701
3 Dave Kreskowiak 627
4 Suvendu Shekhar Giri 568

Advertise | Privacy | Mobile
Web03 | 2.8.150603.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