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

Rick Brandt <rickbrandt2@xxxxxxxxxxx> wrote:
> 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.

Although to confuse things you can use two different workgroup files.
One contains your users, the other the design admins. This way there is
physically no way anyone can login to gain access to your design (tables
usually as I distribute MDE frontends). Of course my user groups have
been created exactly the same in each workgroup else it won't work.

(Although again a simple tool will break the security anyway if one was
really keen to gain access:)
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response


.

Relevant Pages

  • Re: Creating security for MS Access application
    ... security settings seem to be done at a global level on my computer. ... You've "joined" your workgroup file on your machine, ... You've not properly secured your database if that's the case. ... with instructions on how to properly secure a ...
    (microsoft.public.access.security)
  • Re: Creating security for MS Access application
    ... security settings seem to be done at a global level on my computer. ... You've "joined" your workgroup file on your machine, ... You've not properly secured your database if that's the case. ... with instructions on how to properly secure a ...
    (microsoft.public.access.security)
  • Re: Different MDW files
    ... I not really sure, but the security wizard, and the use of a workgroup file ... In any applications that I deploy to a client environment, ... users to security groups, then in fact we NEVER assign a user to a form, ...
    (microsoft.public.access.security)
  • Re: Remove Security from Access
    ... I used User-level Security wizard. ... workgroup file or if you mistakenly applied security using the ... system MDW file that you deleted then you are screwed unless... ... you have a backup of the file from before you applied security ...
    (microsoft.public.access.security)
  • Re: Administrator cant access their own database
    ... > I'm not an expert on access and security and I must have done something wrong. ... > I had a database with a security file working great on my c: ... it chooses which workgroup file to use, ... administrator program or function. ...
    (microsoft.public.access.security)