By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Username and Password for Tracking Purposes

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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" <ro******@saiyanprincefox.cjb.net> wrote in message
news:8N*****************@newsread2.news.atl.earthl ink.net...
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.

Nov 12 '05 #2

P: n/a

"Charles Robinson III" <ro******@saiyanprincefox.cjb.net> wrote in message
news:8N*****************@newsread2.news.atl.earthl ink.net...
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.


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

Nov 12 '05 #3

P: n/a

"Matthew Leskoko" <Ma****@hotmail.com> wrote in message
news:d8******************************@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 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
Nov 12 '05 #4

P: n/a
> "Matthew Leskoko" <Ma****@hotmail.com> wrote in message
news:d8******************************@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 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???


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.
Nov 12 '05 #5

P: n/a

"Peter Doering" <no****@doering.org> wrote in message
news:bn************@ID-204768.news.uni-berlin.de...
"Matthew Leskoko" <Ma****@hotmail.com> wrote in message
news:d8******************************@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 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???


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.


OK, thanks - I just started watching this ng.

Doug
Nov 12 '05 #6

P: n/a

"Doug M" <ow***@nowhere.com> wrote in message
news:3f***********************@news.optusnet.com.a u...

"Peter Doering" <no****@doering.org> wrote in message
news:bn************@ID-204768.news.uni-berlin.de...
"Matthew Leskoko" <Ma****@hotmail.com> wrote in message
news:d8******************************@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 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???


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.


OK, thanks - I just started watching this ng.

Doug


None of these people are MVPs.

Peter Doering is actually Larry Linson.

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

XMVP


Nov 12 '05 #7

P: n/a
"XMVP" <ac***********@hotmail.com> wrote in
news:00******************************@news.teranew s.com:
None of these people are MVPs.

Peter Doering is actually Larry Linson.

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

XMVP


There is only one access_moron. He is soon to get arrested for
selling dope.
Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.