Re: Identify Users W/O Access Security

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
--
Trying To Feed The Hungry


"John Spencer" wrote:

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
..

"EarlCPhillips" <EarlCPhillips@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CD66598E-2AC3-4EB6-A747-EF28A835D17C@xxxxxxxxxxxxxxxx
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
--
Trying To Feed The Hungry



.

Relevant Pages

  • Re: Pass Table as a parameter to a function
    ... there is nothing wrong with being an application programmer. ... The suppliers then agreed to provide packages of 10 units, ... A volunteer programmer did a pull-down list where the package options ... courses, no statistics course, no comp sci courses, no nothing are ...
    (comp.databases.ms-sqlserver)
  • Re: [Fwd: Re: Mainframe not a good architecture for interactive was Re: What is the future of COBOL
    ... I bet Pete was an application programmer and not a system ... Network servers pass messages to each other ... > to a Web Server, this means that for an equal number of clients, a Web ... > server is keeping track of 5 times the connections. ...
    (comp.lang.cobol)
  • RE: Help with guidlines
    ... infrastructure, Network security, etc. ... All 50 laptops were on the network while 3 LAN Admins ... The Programmer brought it in and said ...
    (Security-Basics)
  • Re: Was: Mixed sex Cubs cf Brownies
    ... I have noticed that the local CVS has very little input from Scouts ... I have joined Voluntary Action Network and get regular mailings on goings on ... I used to do some work for Community Action whilst at uni, which is the volunteer focus of most student unions and a counterpart to RAG. ... Community Action at Loughborough, used to work with a range of youthwork stakehoders both within the formal sector and informal section with things like outreach working, but never with Scouting and Guiding. ...
    (uk.rec.scouting)
  • Re: Cant connect via VNC from work to home
    ... >> Anytime you expose your company to something they didn't authorize ... company network being infected and they tracked it back to the programmer. ... needing a remote connection and everyone was prohibited from doing anything ...
    (comp.security.firewalls)