Multiple Frontends?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kctss - 27 Jul 2005 14:05 GMT

Hi,
I have a small Access2k DB, FE & BE. Employees work records are imported
from a Excel SS. I would like to eliminate the Excel import and have
employees enter work logs directly into the DB. The employees will not be
using any of the other report features of the DB, just entering worklogs,
editing them or deleting.
So my question is more of a design issue...do I create multiple frontends?
One for the employees which allows them to input,edit,delete records and then
one for the manager that allows he/she to use all the report funtions etc.
Probably will not be more than eight/nine users.
Thanks

Reply to this Message

Carl Rapson - 27 Jul 2005 15:34 GMT

If there is overlap of the features (for example, managers can
input/edit/delete records as well as use the report functions), you could
use a rudimentary security system. I have a table of users which includes
some value indicating the user's program privileges. The user logs in with a
login form (two text boxes, user name and password), then the main menu form
determines which functions to enable based on the user's privileges. That
way, a manager could (for example) have the Edit and Report buttons enabled,
but an employee would only have the Edit button enabled. Simplistic, I know,
but it works for me, and I only have to have one front-end (albeit with a
lot of IF statements).

HTH,

Carl Rapson

> Hi,
> I have a small Access2k DB, FE & BE. Employees work records are imported
[quoted text clipped - 8 lines]
> Probably will not be more than eight/nine users.
> Thanks

Reply to this Message

Joan Wild - 27 Jul 2005 15:35 GMT

> Hi,
> I have a small Access2k DB, FE & BE. Employees work records are imported
[quoted text clipped - 8 lines]
> Probably will not be more than eight/nine users.
> Thanks

That might be the simplest, since you have only the one person using the
second frontend, and there is no overlap in the FE requirements.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

kctss - 27 Jul 2005 16:16 GMT

There is some overlap in the FE requirements....the manager must also enter
worklogs and be able to edit, etc.

> > Hi,
> > I have a small Access2k DB, FE & BE. Employees work records are imported
[quoted text clipped - 11 lines]
> That might be the simplest, since you have only the one person using the
> second frontend, and there is no overlap in the FE requirements.

Reply to this Message

Joan Wild - 27 Jul 2005 16:41 GMT

> There is some overlap in the FE requirements....the manager must also
> enter
> worklogs and be able to edit, etc.

In that case, I'd grab the user's windows login name and use that to limit
what they can see. For example, assuming you have a Main form/switchboard,
you could make the reporting buttons visible only if the manager is logged
in, etc.

You can use the function at
http://www.mvps.org/access/api/api0008.htm
to grab the login name.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message