User Login for Access

[GitarJake]

Hello all,

What's the best way to login users, then only display data that pertains to
them?

I'm creating an Access Time Clock of sorts, and would rather not have
everyone see everyone else's hours and payrates, etc.

TIA,

Jake

 

[Chris Nebinger]

Three possible ways that I've used in the past:

Use built in Access Security. CurrentUser function will
then return the name of the user that logged in. The
downside is now there is a new username/password for the
user to remember

Use custom login screen. Same as Security, however there
is no security on the tables themselves.

If you don't care about security, and just want to know
who logged in, you could get the OS User name:
http://www.mvps.org/access/api/api0008.htm

This only works if they have to login to the network, then
the database, and will logout. If there is a generic
username used, then one of the first two would be better.


Chris Nebinger