Username and Password for Tracking Purposes

I am getting ready to put a database on a LAN with about 8-users who are
going to be accessing this database. For quality control purposes, for each
record entered, I have a drop down menu which the user will select their
name from, therefore showing who has posted what record to the database. I
was wondering if there would be a way that I could have a username and
password, or just a password, when entered during database startup will
automatically fill in their name in this drop down menu, thus preventing
such confusion.


IN SUMMARY...

1. User Initiates the Database...
2. Enters their username/password...
3. Database automatically fills in their name
according to their username/password
for each NEW record from this user.

re: Username and Password for Tracking Purposes

By applying Access security, so that users have to log in to Access using a
Workgroup file, you can simply use the built-in function CurrentUser to
obtain the userid. Please be sure to download the Security FAQ from
http://www.microsoft.com/downloads -- security isn't quite as simple as some
believe just from reading the online Help.

If you don't really have "security issues", then you may not need to go to
great lengths to secure the database, but securing using a workgroup file so
that Access requires logging in is definitely the approach you should take.

Larry Linson
Microsoft Access MVP



"Charles Robinson III" <robinson@saiyanprincefox.cjb.net> wrote in message
news:8NVkb.6317$W16.3901@newsread2.news.atl.earthl ink.net...[color=blue]
> I am getting ready to put a database on a LAN with about 8-users who are
> going to be accessing this database. For quality control purposes, for[/color]
each[color=blue]
> record entered, I have a drop down menu which the user will select their
> name from, therefore showing who has posted what record to the database.[/color]
I[color=blue]
> was wondering if there would be a way that I could have a username and
> password, or just a password, when entered during database startup will
> automatically fill in their name in this drop down menu, thus preventing
> such confusion.
>
>
> IN SUMMARY...
>
> 1. User Initiates the Database...
> 2. Enters their username/password...
> 3. Database automatically fills in their name
> according to their username/password
> for each NEW record from this user.
>
>[/color]

re: Username and Password for Tracking Purposes

"Charles Robinson III" <robinson@saiyanprincefox.cjb.net> wrote in message
news:8NVkb.6317$W16.3901@newsread2.news.atl.earthl ink.net...[color=blue]
> I am getting ready to put a database on a LAN with about 8-users who are
> going to be accessing this database. For quality control purposes, for[/color]
each[color=blue]
> record entered, I have a drop down menu which the user will select their
> name from, therefore showing who has posted what record to the database.[/color]
I[color=blue]
> was wondering if there would be a way that I could have a username and
> password, or just a password, when entered during database startup will
> automatically fill in their name in this drop down menu, thus preventing
> such confusion.
>
>
> IN SUMMARY...
>
> 1. User Initiates the Database...
> 2. Enters their username/password...
> 3. Database automatically fills in their name
> according to their username/password
> for each NEW record from this user.
>[/color]

Best place to get answers is at the official MVP site:
http://mvp.org
Matthew Leskoko, MVP

re: Username and Password for Tracking Purposes

"Matthew Leskoko" <MatLes@hotmail.com> wrote in message
news:d8778776fbc8d22058e7e9059b5e88a4@news.teranew s.com...[color=blue]
>
> Best place to get answers is at the official MVP site:
> http://mvp.org
> Matthew Leskoko, MVP
>
>
>[/color]

I don't know if my experience is unusual or not but this is the second post
I've seen like this and when I try the site I get two IE windows one of
which is mvp.org but has nothing to do with Access and a lot to do with
Viagra. The other window is totally unrelated and when I try to close it I
get about a half dozen new IE windows that I can only get rid of with Task
Manager. What's up???

Doug

re: Username and Password for Tracking Purposes

> "Matthew Leskoko" <MatLes@hotmail.com> wrote in message[color=blue]
> news:d8778776fbc8d22058e7e9059b5e88a4@news.teranew s.com...[color=green]
>>
>> Best place to get answers is at the official MVP site:
>> http://mvp.org
>> Matthew Leskoko, MVP
>>[/color]
> I don't know if my experience is unusual or not but this is the second post
> I've seen like this and when I try the site I get two IE windows one of
> which is mvp.org but has nothing to do with Access and a lot to do with
> Viagra. The other window is totally unrelated and when I try to close it I
> get about a half dozen new IE windows that I can only get rid of with Task
> Manager. What's up???[/color]

The real MVP's site is www.mvps.org and the poster's real identity is Don
Mellon, who is not MVP but using all sorts of false identities, giving
useless answers like the one above. He won't stop, so just don't bother.
After a while you can recognise his posts easily.

Peter

--
No mails please.

re: Username and Password for Tracking Purposes

"Peter Doering" <nospam@doering.org> wrote in message
news:bn3o24$t8kpv$2@ID-204768.news.uni-berlin.de...[color=blue][color=green]
> > "Matthew Leskoko" <MatLes@hotmail.com> wrote in message
> > news:d8778776fbc8d22058e7e9059b5e88a4@news.teranew s.com...[color=darkred]
> >>
> >> Best place to get answers is at the official MVP site:
> >> http://mvp.org
> >> Matthew Leskoko, MVP
> >>[/color]
> > I don't know if my experience is unusual or not but this is the second[/color][/color]
post[color=blue][color=green]
> > I've seen like this and when I try the site I get two IE windows one of
> > which is mvp.org but has nothing to do with Access and a lot to do with
> > Viagra. The other window is totally unrelated and when I try to close[/color][/color]
it I[color=blue][color=green]
> > get about a half dozen new IE windows that I can only get rid of with[/color][/color]
Task[color=blue][color=green]
> > Manager. What's up???[/color]
>
> The real MVP's site is www.mvps.org and the poster's real identity is Don
> Mellon, who is not MVP but using all sorts of false identities, giving
> useless answers like the one above. He won't stop, so just don't bother.
> After a while you can recognise his posts easily.
>
> Peter
>
> --
> No mails please.[/color]

OK, thanks - I just started watching this ng.

Doug

re: Username and Password for Tracking Purposes

"Doug M" <owner@nowhere.com> wrote in message
news:3f95cf4c$0$21649$afc38c87@news.optusnet.com.a u...[color=blue]
>
> "Peter Doering" <nospam@doering.org> wrote in message
> news:bn3o24$t8kpv$2@ID-204768.news.uni-berlin.de...[color=green][color=darkred]
> > > "Matthew Leskoko" <MatLes@hotmail.com> wrote in message
> > > news:d8778776fbc8d22058e7e9059b5e88a4@news.teranew s.com...
> > >>
> > >> Best place to get answers is at the official MVP site:
> > >> http://mvp.org
> > >> Matthew Leskoko, MVP
> > >>
> > > I don't know if my experience is unusual or not but this is the second[/color][/color]
> post[color=green][color=darkred]
> > > I've seen like this and when I try the site I get two IE windows one[/color][/color][/color]
of[color=blue][color=green][color=darkred]
> > > which is mvp.org but has nothing to do with Access and a lot to do[/color][/color][/color]
with[color=blue][color=green][color=darkred]
> > > Viagra. The other window is totally unrelated and when I try to close[/color][/color]
> it I[color=green][color=darkred]
> > > get about a half dozen new IE windows that I can only get rid of with[/color][/color]
> Task[color=green][color=darkred]
> > > Manager. What's up???[/color]
> >
> > The real MVP's site is www.mvps.org and the poster's real identity is[/color][/color]
Don[color=blue][color=green]
> > Mellon, who is not MVP but using all sorts of false identities, giving
> > useless answers like the one above. He won't stop, so just don't bother.
> > After a while you can recognise his posts easily.
> >
> > Peter
> >
> > --
> > No mails please.[/color]
>
> OK, thanks - I just started watching this ng.
>
> Doug
>
>[/color]

None of these people are MVPs.

Peter Doering is actually Larry Linson.

Write to me at access_morons@hotmail.com to get the complete dope on phony
MVPs.

XMVP

re: Username and Password for Tracking Purposes

"XMVP" <access_morons@hotmail.com> wrote in
news:0086cb4d736332ecb9f86d720bb0eda4@news.teranew s.com:
[color=blue]
> None of these people are MVPs.
>
> Peter Doering is actually Larry Linson.
>
> Write to me at access_morons@hotmail.com to get the complete
> dope on phony MVPs.
>
> XMVP[/color]

There is only one access_moron. He is soon to get arrested for
selling dope.