Re: UserName

Hi Jack,

I still haven't tried out the CurrentUser() function.
No time yet, and also I have to prepare for it. Last time I initiated
security I was locked out of all of my Access dbs for a couple of
days, very scary stuff.

Assuming I can get the function to work for me, would you know if I
could have my staff access the db on a server without splitting the
db?
I'd like to know if it's possible and what if anything would be the
downside to not splitting?

Thanks! Eric



On Mon, 23 Jun 2003 04:31:40 GMT, Jack MacDonald
<jackMACmacdonald@telus.net> wrote:

>Yes - that is possible. The CurrentUser() function returns the name of
>the current, logged-in Access user. Use the form's OnOpen event to
>populate a textbox with the name returned by CurrentUser().
>
>Sub Form_Open
> txtSomeTextBox.Value = CurrentUser()
>End Sub
>
>
>
>
>On Sun, 22 Jun 2003 03:35:16 GMT, Eric@ether.net (Eric G) wrote:
>
>>Is it possible to set up the Access/Access security
>>(UserName/Password) in such a way that when a particular form is
>>opened, the UserName that was entered to get into Access is
>>automatically entered into a control in the form?
>>
>>This is the way I currently have my .mdb file set up (without using
>>security). That is, a user logs in a user name and password on a form
>>and if the password is correct, another form opens with the user's
>>name/code entered into a control.
>>
>>If it's not possible to set up Access security in the same way that I
>>now have my user/pass functioning, can I implement Access security and
>>protect my .mdb from having two/three users logging into my main form
>>with two/three usercodes?
>>
>>I hope I've made myself clear.
>>
>> TIA Eric
>
>
>=======================================================
>Jack MacDonald
>remove UPPERCASE LETTERS from email address
>Vancouver, B.C. Canada
>Info about MSAccess user-level security
>www.geocities.com/jacksonmacd

On Fri, 27 Jun 2003 04:22:05 GMT, Eric@ether.net (Eric G) wrote:

>Hi Jack,
>
> I still haven't tried out the CurrentUser() function.
> No time yet, and also I have to prepare for it. Last time I initiated
>security I was locked out of all of my Access dbs for a couple of
>days, very scary stuff.

See the document on the website in my signature for some advice.

>
>Assuming I can get the function to work for me, would you know if I
>could have my staff access the db on a server without splitting the
>db?
>I'd like to know if it's possible and what if anything would be the
>downside to not splitting?

Possible... but definitely NOT recommended. Splitting the database is
recommended in almost EVERY situation. Furthermore, you place a copy
of the frontend on each workstation for maximum performance and
stability.
see: http://www.granite.ab.ca/access/splitapp.htm


>
> Thanks! Eric
>
>
>
>On Mon, 23 Jun 2003 04:31:40 GMT, Jack MacDonald
><jackMACmacdonald@telus.net> wrote:
>
>>Yes - that is possible. The CurrentUser() function returns the name of
>>the current, logged-in Access user. Use the form's OnOpen event to
>>populate a textbox with the name returned by CurrentUser().
>>
>>Sub Form_Open
>> txtSomeTextBox.Value = CurrentUser()
>>End Sub
>>
>>
>>
>>
>>On Sun, 22 Jun 2003 03:35:16 GMT, Eric@ether.net (Eric G) wrote:
>>
>>>Is it possible to set up the Access/Access security
>>>(UserName/Password) in such a way that when a particular form is
>>>opened, the UserName that was entered to get into Access is
>>>automatically entered into a control in the form?
>>>
>>>This is the way I currently have my .mdb file set up (without using
>>>security). That is, a user logs in a user name and password on a form
>>>and if the password is correct, another form opens with the user's
>>>name/code entered into a control.
>>>
>>>If it's not possible to set up Access security in the same way that I
>>>now have my user/pass functioning, can I implement Access security and
>>>protect my .mdb from having two/three users logging into my main form
>>>with two/three usercodes?
>>>
>>>I hope I've made myself clear.
>>>
>>> TIA Eric
>>
>>
>>=======================================================
>>Jack MacDonald
>>remove UPPERCASE LETTERS from email address
>>Vancouver, B.C. Canada
>>Info about MSAccess user-level security
>>www.geocities.com/jacksonmacd


=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd

On Sat, 28 Jun 2003 04:54:38 GMT, Eric@ether.net (Eric G) wrote:

>Hi Jack,
>
>
>>See the document on the website in my signature for some advice.
>
> OK will do.
>
>
>>Possible... but definitely NOT recommended. Splitting the database is
>>recommended in almost EVERY situation. Furthermore, you place a copy
>>of the frontend on each workstation for maximum performance and
>>stability.
>>see: http://www.granite.ab.ca/access/splitapp.htm
>
> Thanks I'll read up on this too.
>
>One more question. Assuming I can get the call function working for
>me, how could I quickly input ~60 user codes and passwords into Access

Depends on your typing speed ;-) 30 sec per user?

>security? Right now with my log-in form, I just match the user code
>typed in with a table of user codes.
>I'd like to avoid having to key in all of that data again.

Probably better off to just retype it, rather than writing some code
to extract the info from your table and entering it programmatically
into the account definitions. I am not aware of anything off-the-shelf
to do that task.


>
> Thanks! Eric


=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd