Split Database Security Problem

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
.

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