I would like to log in one of the databases the username of the person who is
making changes to a record in a database, but I noticed that access 2207
doesn't have user level security anymore and the currentuser method just
returns admin. Is there a way to do this?

On Jan 3, 10:16 am, icccapital <icccapi...@discussions.microsoft.com>
wrote:
> I would like to log in one of the databases the username of the person who is
> making changes to a record in a database, but I noticed that access 2207
> doesn't have user level security anymore and the currentuser method just
> returns admin. Is there a way to do this?

I can think of several ways:

- Implement your own user authentication to track users - not
difficult but not very secure.
- Use SQL Server Express' user security (v. secure, easy, but only one
user per 'session').
- Snag the windows login ID if that's reliable (ie. users not sharing
IDs).

-- James

Is there a function for getting the windows login id?

"Minton M" wrote:

> On Jan 3, 10:16 am, icccapital <icccapi...@discussions.microsoft.com>
> wrote:
> > I would like to log in one of the databases the username of the person who is
> > making changes to a record in a database, but I noticed that access 2207
> > doesn't have user level security anymore and the currentuser method just
> > returns admin. Is there a way to do this?
>
> I can think of several ways:
>
> - Implement your own user authentication to track users - not
> difficult but not very secure.
> - Use SQL Server Express' user security (v. secure, easy, but only one
> user per 'session').
> - Snag the windows login ID if that's reliable (ie. users not sharing
> IDs).
>
> -- James
>

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

--
HTH,
George


"icccapital" <(E-Mail Removed)> wrote in message
news:AF024972-0378-40DC-BE49-(E-Mail Removed)...
> Is there a function for getting the windows login id?
>
> "Minton M" wrote:
>
>> On Jan 3, 10:16 am, icccapital <icccapi...@discussions.microsoft.com>
>> wrote:
>> > I would like to log in one of the databases the username of the person
>> > who is
>> > making changes to a record in a database, but I noticed that access
>> > 2207
>> > doesn't have user level security anymore and the currentuser method
>> > just
>> > returns admin. Is there a way to do this?
>>
>> I can think of several ways:
>>
>> - Implement your own user authentication to track users - not
>> difficult but not very secure.
>> - Use SQL Server Express' user security (v. secure, easy, but only one
>> user per 'session').
>> - Snag the windows login ID if that's reliable (ie. users not sharing
>> IDs).
>>
>> -- James
>>

Ok thanks. I had found that but wasn't sure if there was a prepackaged
function in the api I could use. Thanks

"George Nicholson" wrote:

> http://mvps.org/access/api/api0008.htm
>
> --
> HTH,
> George
>
>
> "icccapital" <(E-Mail Removed)> wrote in message
> news:AF024972-0378-40DC-BE49-(E-Mail Removed)...
> > Is there a function for getting the windows login id?
> >
> > "Minton M" wrote:
> >
> >> On Jan 3, 10:16 am, icccapital <icccapi...@discussions.microsoft.com>
> >> wrote:
> >> > I would like to log in one of the databases the username of the person
> >> > who is
> >> > making changes to a record in a database, but I noticed that access
> >> > 2207
> >> > doesn't have user level security anymore and the currentuser method
> >> > just
> >> > returns admin. Is there a way to do this?
> >>
> >> I can think of several ways:
> >>
> >> - Implement your own user authentication to track users - not
> >> difficult but not very secure.
> >> - Use SQL Server Express' user security (v. secure, easy, but only one
> >> user per 'session').
> >> - Snag the windows login ID if that's reliable (ie. users not sharing
> >> IDs).
> >>
> >> -- James
> >>
>
>
>