how to make an access database read only
I want to make an access 2010 database read only so that no one can change the records that are in it. How do I do that?
Actually I meant Read Only ... using a Command Line Prompt
Open Read Only
"C:\Program Files\Microsoft Office\Office12\msaccess.e
You could also put it on a CD Rom.
mx
Open Read Only
"C:\Program Files\Microsoft Office\Office12\msaccess.e
You could also put it on a CD Rom.
mx
ASKER
I need to make sure no one else can open it and edit it. How do I do that so that no one else has the ability to make changes?
If you mean directly open it, ie a user can directly open the db via what ever means, then about the only thing you can do is put it on a CD ROM ... because User Level Security is no longer available as of A2007.
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Of course, any savvy user can simply uncheck that setting ...
And of course, they can copy a db from a CD ROM to a local folder.
I think the bottom line is ... nothing will be 100 % ...
mx
And of course, they can copy a db from a CD ROM to a local folder.
I think the bottom line is ... nothing will be 100 % ...
mx
- agree with MX.
- here is another approach of making the data readonly by creating a form to display your data and make it read only. therefore user will not have access to your table directly:
https://www.experts-exchange.com/questions/24901227/Best-Read-Only-Access.html?sfQueryTermInfo=1+10+30+access+onli+read
- here is another approach of making the data readonly by creating a form to display your data and make it read only. therefore user will not have access to your table directly:
https://www.experts-exchange.com/questions/24901227/Best-Read-Only-Access.html?sfQueryTermInfo=1+10+30+access+onli+read
You can also create macro's to open your tables or queries in read-only mode. Tie those to your switchboard along with any forms. Then hide your tables on open to prevent the curious out of the data.As was mention before depending on the user's knowledge some can get around this. I work in a large company and havn't had anyone stumble thier way into something I didn;t want them to see.
"therefore user will not have access to your table directly:"
The *bottom line* here is ... IF ... the user can get to the MDB - and there is really no way to prevent that generally, then they can get in. Using a form or making the db read only in Explorer is really not going to do much of anything.
mx
The *bottom line* here is ... IF ... the user can get to the MDB - and there is really no way to prevent that generally, then they can get in. Using a form or making the db read only in Explorer is really not going to do much of anything.
mx
The answer to this question is ... in A2010 ... it really cannot be done for all practical purposes.
mx
mx
mx