If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
User Login for Access
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 |
#2
|
|||
|
|||
User Login for Access
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 -----Original Message----- 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 . |
Thread Tools | |
Display Modes | |
|
|