Hi, how to get the username on currentdb? Hope's this clear.
R Rob Parker Sep 30, 2011 #2 If you mean the Windows login name of the current user (as opposed to the Access user name, which will be 'admin' unless you're using Access User Level Security), see http://access.mvps.org/access/api/api0008.htm HTH, Rob
If you mean the Windows login name of the current user (as opposed to the Access user name, which will be 'admin' unless you're using Access User Level Security), see http://access.mvps.org/access/api/api0008.htm HTH, Rob
A Arvin Meyer Oct 1, 2011 #3 belinda shu said: Hi, how to get the username on currentdb? Hope's this clear. Click to expand... If you have security enabled with an MDB, you can use the built-in CurrentUser() function. If security is not enabled, it will return: admin For the Windows login name use: http://access.mvps.org/access/api/api0008.htm For the full name of the currently logged in user: http://access.mvps.org/access/api/api0066.htm For a remotely logged in user: http://access.mvps.org/access/api/api0062.htm and lastly, for the computer logged in name: http://access.mvps.org/access/api/api0009.htm -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://access.mvps.org Co-author: "Access Solutions", published by Wiley
belinda shu said: Hi, how to get the username on currentdb? Hope's this clear. Click to expand... If you have security enabled with an MDB, you can use the built-in CurrentUser() function. If security is not enabled, it will return: admin For the Windows login name use: http://access.mvps.org/access/api/api0008.htm For the full name of the currently logged in user: http://access.mvps.org/access/api/api0066.htm For a remotely logged in user: http://access.mvps.org/access/api/api0062.htm and lastly, for the computer logged in name: http://access.mvps.org/access/api/api0009.htm -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://access.mvps.org Co-author: "Access Solutions", published by Wiley
