access addin to open db in read-only mode

Question

1.00/5 (1 vote)

See more:

I am new to addin development. I have to develop an addin for MS Access that will allow the user to open any database strictly in readonly mode

If not all can we at least make a single database readonly. Hardcode the name and path of the database if required.The DB will be readonly in access but should be appendable/editable using sql scripts fired from my .net project.

Further i will enable or disable this setting based on some registry value so that an authenticated person shall be able to edit the databases.

I would appreciate if we NOT use any username/password based authentication

Posted 19-Feb-10 0:11am

ninadcsl

Updated 4-Mar-10 17:56pm

v2

Add a Solution

1 solution

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)

DaveAuld · Answer 1 · 2010-03-05T00:43:00

Any database file opened by Access will be read/write unless you use some form of authentication.

You could use NTFS security permission on a folder or you could use Database Level security.

If you have a mdb file sat on a server, there is nothing stopping someone else opening it with Access directly if you see what i mean. I do not think there is any way to easily achieve what you want without having to use security at some point in the process.

The only way to use some form of Add-in type option via the registry, would be to modify the connection string use to open the database and set the Read-Only flag within it, but this would be bypassable using other software e.g. stand-alone MSAccess, Excel etc.