Acces Security without unique accounts

[David R. Eaton]

I am using ACCESS as a front end for a SQL database. The database is
basically a trouble call tracking system and I want to implement queues for
different technicians. Is there a way to determine who is logged onto the
workstation and either map them to a user within the database or forgo
internal access accounts all together and just use the Domain credentials
within the database. I really do not want to create accounts for our
rotating technical personnel and maintain a whole sepparate password list. I
don't have time to manage another monster.

Any info is appreciated. Feel free to respond via e-mail to
(e-mail address removed)

 

[Albert D. Kallal]

You can get the current network logon name with:

http://www.mvps.org/access/api/api0008.htm

And, the current computer name with:

http://www.mvps.org/access/api/api0009.htm

And, if using ms-access security, then currentuser() will return the
ms-access
logon.

I *often* log all 3 of the above values in some applications.

 

[KW]

You can also handle it in your ODBC Definition. There is a
spot for a username and password when your setting the
ODBC connection up. set a user on the SQL server that is
generic that has whatever permissions you want the general
user to have. The set that username and password in the
ODBC defiunitioin on the users computer.

Hope that helps.