How to control MS Access Database permission security by using C# code?

Question

How to allow read and write both permission to everyone by using code in C#?

Amit Gupta · Answer

You can try either of the below option 1. If the file attribute is readonly then you can change its properties to normal (this can also done through code also like File.SetAttributes(filePathFileAttributes.Normal); 2. Add a manifest your program and set uiinvoker to administrator 3. Try changing the path of your db eg. C:\ProgramData Dolet me know if it works

harendra prakash · Answer

I have got the solution for the issue. Thanks everyone

Laxmidhar Sahoo · Answer

right click on the file and click on properties like beloow pic. Click on security tab on the top and then advance button on button Again click on advance and then change permission Click on edid and at last allow

harendra prakash · Answer

To set your program to run as administrator look at the below link https://stackoverflow.com/questions/2818179/how-do-i-force-my-net-application-to-run-as-administrator This is also not working.. i m trying to go for 3rd one.. lets see

Amit Gupta · Answer

To set your program to run as administrator look at the below link https://stackoverflow.com/questions/2818179/how-do-i-force-my-net-application-to-run-as-administrator But it was quite annoying for user for accepting the prompt raised by UAC. If possible you can go for the 3rd option and proceed with the current one. Good Luck

harendra prakash · Answer

Thanks for reply @ Amit first one is not working and for second option i dont know how to set uninvoker to administrator but there is app.manifest file already available in the project

harendra prakash · Answer

permission to perform operation like insert delete and update MS Access file turns into read only mode after creating setup so it prevent my code to write into database. Now my application is just reading data

Amit Gupta · Answer

What kind of permission you want to implement elaborate your question