How Can I Make Microsoft Access Database Read Only By c#?

Question

0.00/5 (No votes)

See more:

hi all.
i have an access database.i just want to make it read only to make sure that no one can edit it's tables?
i mean users(other users of my PC) can open and see tables and can edit all data!in this case there is no difference between admin and users.
i need a way to lock it or make it read only or ...
is there any way?

Posted 22-Feb-14 12:18pm

Farshad72

Updated 22-Feb-14 12:19pm

v2

Add a Solution

Comments

pharap@hotmail.com 23-Feb-14 9:18am

I'd like to note that Macros for Access are written in VB if you want to look into programming for Access. Although you don't need any programming knowledge to make an Access database read-only.

Farshad72 23-Feb-14 9:37am

Ok!
thanks!

2 solutions

Solution 2

and if you are concerned with keeping your data safe. Please add a password to the database and also add password in the connection string. So, that your software can access it.

Posted 22-Feb-14 17:07pm

agent_kruger

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

ZurdoDev · Accepted Answer · 2014-02-22T13:25:00

Solution 1

You actually do not need any code to do security in Access. It is built in. I would suggest reading through the help file and also reviewing this site, http://msdn.microsoft.com/en-us/library/office/aa139961(v=office.10).aspx[^]

Posted 22-Feb-14 13:25pm

ZurdoDev

Comments

Farshad72 22-Feb-14 19:58pm

thanks.
codes are not written in C#.net .do you have any?

ZurdoDev 22-Feb-14 20:09pm

You don't need code.

Garth J Lancaster 22-Feb-14 20:11pm

whoops - hopefully I replied to Farshad72 and not you - sorry

Garth J Lancaster 22-Feb-14 20:10pm

I don't think you read or understood what RyanDev was saying - you do not need code to do this - you make sure that the user accessing the database has the correct permissions to the tables - in this case, 'read-only' type permissions - its how the database access/roles are set up, nothing to do with c#

If you are saying you want code in c# to modify the access/roles, that's a different matter

Farshad72 22-Feb-14 20:22pm

i understood that i can set a password Manually,but there was a "Set a Database Password Programmatically" title and the code was in vb i think.

ZurdoDev 22-Feb-14 20:23pm

What code? You can likely do this through code but you don't need. Perhaps you need to be more clear on what you need.

Farshad72 22-Feb-14 20:28pm

i am just learning. i think it is better to know all aspect . you are right .thanks

Farshad72 22-Feb-14 20:26pm

there was a title that explain how to convert MS to MDE file.with this 4 steps:
To convert an .mdb file to an MDE file:
Close the database.
Click Database Utilities on the Tools menu.
Click Make MDE File.
In the Database to Save as MDE dialog box, locate the .mdb file, and click Make MDE.
but i can not find second step!i have an old version of office(2007)

Garth J Lancaster 22-Feb-14 20:54pm

ok, I havnt worked with MSACCESS in soooo long - but for example, using the MsSql Dot Net C# connector, I could execute a statement along the lines of [GRANT Permissions x on user y] Sort of thing - you may be able to do same sort of thing in MSACCESS - its the closest thing I can think of, but is still unnecessary if the DB is set up properly in the first place

Farshad72 22-Feb-14 21:02pm

tnx