Activate different FE apps

[Ian]

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

 

['69 Camaro]

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.

 

['69 Camaro]

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.

 

[Ian]

Hi Gunny,

Thanks for the comprehensive reply. Your first reply kind of confirmed what
I was thinking but thought there maybe an expert solution I didn't know
about. The link to Jeff's article looks interesting and I shall give that a
good read and see if I can fit it to my situation.

Thanks again,
Ian.

 

['69 Camaro]

Hi, Ian.

You're welcome. Good luck with it.

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.