Identify Users W/O Access Security

[Guest]

I enhanced a system used to track volunteers at the local food bank who sort
donated food. They must schedule their time by calling in and finding out
when time is available (enough supervisors, not too many other people here).
We have found too many volunteers arriving with inappropriate footware, too
young, incorrect instructions, etc. The manager wants to know who is
physically entering the scheduling of these people.

We do not have the Access User Security installed and I don't yet know how
to administer it. We run everything over the network and the files are
separated from the programming module on the network server.

I have heard there is a way to extract the Network ID of whoever is signed
on to place in a field during scheduling-record creation. Alternately, I
have heard there is a downloadable module from Microsoft that will help me do
similar things. We want to pin down who is making all the mistakes and train
them how to properly brief potential volunteers. Any help would be
appreciated.

EarlCPhillips
Volunteer Ex-mainframer Learning Access Programming
To Feed The Hungry Via Harvesters Food Network

 

[John Spencer]

In a module

Private Declare Function apiGetUserName Lib "advapi32.dll" _
Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

Function fOSUserName() As String
'Returns the network login name
Dim lngLen As Long, lngX As Long
Dim strUserName As String
strUserName = String$(254, 0)
lngLen = 255
lngX = apiGetUserName(strUserName, lngLen)
If lngX <> 0 Then
fOSUserName = Left$(strUserName, lngLen - 1)
Else
fOSUserName = ""
End If
End Function

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

I am a retired programmer and only volunteer three days a week, so it took me
until today to actually try this. It works as claimed and even works on my
local PC because the network requires that I sign on to access my network
drives on the server.

Again you have come to the aid of this aspiring Access programmer. Could
you give me the name of a good book that covers things like this so I can
improve without having to go to the forum for help so often. This volunteer
system is becoming so capable that the staff is recommending it to other food
banks.

EarlCPhillips
Ex-mainframer Aspiring to Access Knowledge
To Help Harvesters Food Network

 

[John W. Vinson]

Again you have come to the aid of this aspiring Access programmer. Could
you give me the name of a good book that covers things like this so I can
improve without having to go to the forum for help so often. This volunteer
system is becoming so capable that the staff is recommending it to other food
banks.

Congratulations! Doesn't that feel great!?

At the level you're working, I'd really suggest the Access 200x Developer's
Handbook by Getz, Litwin and Gilbert (Sybex Press). Huge book, pricy, but
worth every penny for a serious advanced developer.

John W. Vinson [MVP]