Click here to Skip to main content
12,942,930 members (59,941 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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 10-Aug-12 2:50am
how can i change the folder and specify it in the installer?
Mehdi Gholam 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
Top Experts
Last 24hrsThis month
OriginalGriff 4,633
CHill60 2,880
Maciej Los 2,268
Jochen Arndt 1,900
ppolymorphe 1,755

Advertise | Privacy | Mobile
Web01 | 2.8.170518.1 | Last Updated 10 Aug 2012
Copyright © CodeProject, 1999-2017
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