Re: Split Database Security Problem

carriolan@ wrote:
> Hi
> I have managed to secure a split database. Both frontend and backend
> share a common workgroup, common security groups and common users and
> permissions, but as in all good stories there is a catch.
>
> All works well for the newAdmin user, but not so for the newUser. In
> the AutoExec macro I have a call on some VBA to reconnect the frontend
> and backend databases. It does not reconnect for the newUser. My
> conclusion is that the security permissions are not generous enough to
> permit reconnection! The newAdmin for the 'object database' has the
> following permissions: Open/Run, Open Exclusive and Administer. The
> newUser only has: Open/Run, Open Exclusive on the 'database object'.
> The backend dBase only contains tables which are linked to the
> frontend.
>
> How do I set the permissions to get the frontend to auto reconnect to
> the backend please?
>
> Regards
> Carriolan

You need to give the user design permissions to the linked tables in the
front end. They will not be able to change the table design if you
maintain no design permissions in the back end.
--
regards,

Bradley

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


.

Relevant Pages

  • Re: Split Database Security Problem
    ... Both frontend and backend ... > permissions, but as in all good stories there is a catch. ... The newAdmin for the 'object database' has the ...
    (comp.databases.ms-access)
  • RE: Form on front end loading slowly
    ... I gather the user has a frontend that uses a backend database on a server ... > have a database backend with a table that lists employees, ...
    (microsoft.public.access.formscoding)
  • Re: Multi users Logon Security questions
    ... > The next thing I need to do is split the database so others can work ... and navigate to the mdb - copy the mdb. ... You can use your desktop shortcut (which will open your frontend). ... Ctrl-O and open the backend mdb. ...
    (microsoft.public.access.security)
  • Split Database Security Problem
    ... I have managed to secure a split database. ... Both frontend and backend ... permissions, but as in all good stories there is a catch. ...
    (comp.databases.ms-access)
  • Re: Help - Shared MDE - Exclusive Access message box
    ... I have a MS Access 2003 database having 3 files: ... The shortcut points to MDE file and includes /wrkgrp for the MDW ... Each user should have a copy of the frontend MDE on their local workstation. ... would put all the users in a group that has administer permissions in the ...
    (microsoft.public.access.security)