Re: Split Database Security Problem

<carriolan@> wrote in message
news:t1alq1ltv0r6ncb4gc4oqk8sve8q7b2ji7@xxxxxxxxxx
> 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

Log on as admin and link the tables manually. Temporarily comment out the
code which does the re-linking. Log in as user. Does everything else work
OK? Forms, tables queries, etc?
If the answer is yes, then it would appear to be only the re-linking
routine. Does it refresh the links or delete and re-create them? You will
probably need to assign more generous permissions to the front-end linked
tables - eg let standard users alter the design of them so they can be
re-connected and don't worry - those permissions are only on the linked
table - they couldn't change the design of the real back end tables.






.

Relevant Pages

  • 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: 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: 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)