Re: Activate different FE apps

Hi, Ian.

In case you have separate front ends because they have different functionality
(it sounds from your description that you only wanted different access rights),
then you may be interested in Access MVP Jeff Conrad's (AKA "the Access Junkie")
tutorial, "Creating A Custom Login Screen For A Secured Database." You can find
a link to his tutorial on the following Web page:

http://www.Access.QBuilt.com/html/articles.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.


"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:C7B6D16C-7C49-4FDC-9179-DA2B1A646EE2@xxxxxxxxxxxxxxxx
Hi, Ian.

I was wondering if it is possible to have different FE files linked to the
different user groups

Database files need workgroup files, but they don't really "link" to them.
Only tables can be linked to. One my "join" a workgroup to open a particular
database file, because that was the workgroup file used to secure the
database. This can be done with the Workgroup Administrator, but more
commonly a Windows shortcut is used to open the database file while joined to
the secure workgroup for that particular user session, but the user remains
joined to the default (unsecure) workgroup for all other sessions. For
example (this is all one line):

"C:\Program Files\Microsoft Office\OFFICE\MSAccess.exe" "C:\Data\MyDB.mdb"
/wrkgrp "C:\Data\Secure.mdw"

In your scenario, I would have one workgroup file with multiple groups --
one for each level of access rights -- and have all the users open the same
front end database file while joined to that workgroup. However, if you want
to increase maintenance time and effort, you could build multiple front ends
and multiple workgroups. Each user would use his own shortcut that joins to
the secure workgroup he needs to sign into for his particular level of access
rights and open his appropriate front end. But that sounds like a lot of
extra work for the developer to maintain this setup.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.


"Ian" wrote:

I have a secured db on our works server with a number of different user
groups with their associated passwords depending on a users level of access.
I was wondering if it is possible to have different FE files linked to the
different user groups so when one person logging onto a PC FE #1 opens then
user two logs on in a different user group, with greater rights and gets FE
#2 that allows him to do more, etc upto me as Admin who would have my own FE
that allows me to do everything to the db.

Thanks for your help and Happy New Year


.

Relevant Pages

  • Re: Activate different FE apps
    ... Database files need workgroup files, but they don't really "link" to them. ... commonly a Windows shortcut is used to open the database file while joined to ... different user groups so when one person logging onto a PC FE #1 opens then ...
    (microsoft.public.access.security)
  • Re: password problems
    ... I assume it is asking for a UserID and PAssword, ... Or rejoin the SYSTEM.MDW workgroup file. ... There is more to securing a database file than ... > different computer it opens fine and it says that that it is open under ...
    (microsoft.public.access.security)
  • Re: Setting up security level
    ... it will give you an option to 'join' a workgroup. ... but you would like to force your database to open with the ... computer and opens your database without signing on. ... There is a "Security FAQ" on the Microsoft website that talks about how to ...
    (microsoft.public.access.security)
  • Re: Identical user names, different DB
    ... > shortcut was to direct you to the correct wrkgroup file. ... Actually the workgroup administrator does not tell you the current workgroup ... mdw files do. ... > opens right up. ...
    (microsoft.public.access.security)
  • Re: security only works on my PC
    ... workgroup administrator to rejoin the system.mdw workgroup file that ships ... saw the new workgroup I created when I added security. ... no matter what mdb you open). ... just opens to the first screen, and then when they try to look at ...
    (microsoft.public.access.security)