Re: How to set up read-only accessibility to an existing .mdb

RLN wrote:
>>> To do it properly you'd need to implement obviously workgroup
>>> security<<
>
> I have never worked with Jet security before. Is it pretty
> straightforward or are there some resources that would be helpful in
> walking me through setting it up?
> Reason I ask is, I have my application broke up into 2 .mdb files:
>
> MyApp.mdb and MyAppData.mdb.
>
> The data version has all the tables only, while the other has all the
> forms, controls, modules, report, etc.
>
> MyApp.mdb has links to tables in MyAppData. Do I set up the workgroup
> security in MyApp.mdb or MyAppData.mdb for the users to have pure
> "read-only" accessibility to all table for creating adhoc
> reports/queries?

If you go with User Level Security you would need it on BOTH files.
Security is controlled by the workgroup file and there is only one of those
per Access session so the file you open directly and any file that is has
links to are all affected by it.

If you want ALL users to be read only you can simply place the data file in
a folder where they have read-only permissions. If you want some to be
limited to read only and others to be able to edit data, then User Level
Security is the way to go. Network permissions cannot be used for that.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: open exclusive for back end design
    ... >> password but i would like to secure the be with user level security.I ... you can open the backend and set the password. ... > frontend, and delete the links. ... > If you want to implement user level security on the backend, ...
    (microsoft.public.access.security)
  • Re: User security for ~120 organizations
    ... This is an appropriate use for User Level Security, ... populate the field in the tables with the value of CurrentUser() ... Should I try this with the user-level security wizard? ...
    (microsoft.public.access.security)
  • Re: A2007 Security
    ... enable the ShiftKey ByPass on my database? ... Create the bypass key property using the DDL argument so that only an ... administrator can change the setting (assumes you have set up user level ... security in A2000 prevented them from opening the tables or queries ...
    (comp.databases.ms-access)
  • Re: open exclusive for back end design
    ... you can open the backend and set the password. ... frontend, and delete the links. ... If you want to implement user level security on the backend, ... Follow the steps outlined in the security FAQ. ...
    (microsoft.public.access.security)
  • Re: User Levels ?
    ... Keep in mind if your using user level security in ms-access, ... As mentioned you would replace the security group "DeleteInvoice" with the ... access 2007 (it still works if you use the mdb format, ...
    (microsoft.public.access.formscoding)