User Name / Password set-up

[Steve via AccessMonster.com]

I am deploying my app to 23 users who all have Access v2002 runtime on their
pc's - bear with me, as I have no security / username experience. Since I'm
using runtime, I'm not worried about users saboutaging my db accidentally,
because with run-time there is very little they can do.

All I want is a field in my tables that is called LastUpdate - when the user
clicks on the icon to launch the run-time, they will be prompted to enter
their username/password. When they perform new input of records or edits,
this field will be populated. I've tried using the wizards, but they are
somewhat involved, drilling down to the level of WHICH objects I want to give
each user permission to - I just want to set up usernames / passwords -
that's all

Thanks !

 

[George Nicholson]

Possible solution:

http://www.mvps.org/access/api/api0008.htm will get you the user's
NetworkID. You don't even have to ask them (unless you have people sharing
machines).

That being taken care of, simple database security may be sufficient for you
(Tools>Security>Set Database Password). The user is only prompted for a
Password.

When changes are made, grab the UserID via code & update your field(s).

HTH,

 

[Steve via AccessMonster.com]

George,
Thanks - I checked out the link - you didn't mean use that code to get uname ?
I was thinking more like code in a before update procedure

I have this already:

*********************************************
Private Sub Form_BeforeUpdate(Cancel As Integer)

Me.LastModBy = CurrentUser

End Sub
**********************************************

but that just returns "ADMIN" in my source table...

Possible solution:

http://www.mvps.org/access/api/api0008.htm will get you the user's
NetworkID. You don't even have to ask them (unless you have people sharing
machines).

That being taken care of, simple database security may be sufficient for you
(Tools>Security>Set Database Password). The user is only prompted for a
Password.

When changes are made, grab the UserID via code & update your field(s).

HTH,

I am deploying my app to 23 users who all have Access v2002 runtime on
their

[quoted text clipped - 14 lines]

Thanks !

 

[George Nicholson]

you didn't mean use that code to get uname ?
yep, exactly what i meant, because:

CurrentUser...just returns "ADMIN" in my source table...

that's all *Access'* CurrentUser property will ever return unless you go
with Access' full-blown user security, which your 1st post indicated was
more than what you wanted. The routine I suggested will give you the
CurrentUser's Network ID.

HTH,
--
George Nicholson

Remove 'Junk' from return address.

George,
Thanks - I checked out the link - you didn't mean use that code to get
uname ?
I was thinking more like code in a before update procedure

I have this already:

*********************************************
Private Sub Form_BeforeUpdate(Cancel As Integer)

Me.LastModBy = CurrentUser

End Sub
**********************************************

but that just returns "ADMIN" in my source table...

Possible solution:

http://www.mvps.org/access/api/api0008.htm will get you the user's
NetworkID. You don't even have to ask them (unless you have people sharing
machines).

That being taken care of, simple database security may be sufficient for
you
(Tools>Security>Set Database Password). The user is only prompted for a
Password.

When changes are made, grab the UserID via code & update your field(s).

HTH,

I am deploying my app to 23 users who all have Access v2002 runtime on
their

[quoted text clipped - 14 lines]

Thanks !

 

[Steve via AccessMonster.com]

OK, so my code will grab the user ID - thanks !

Steve

you didn't mean use that code to get uname ?

yep, exactly what i meant, because:

CurrentUser...just returns "ADMIN" in my source table...

that's all *Access'* CurrentUser property will ever return unless you go
with Access' full-blown user security, which your 1st post indicated was
more than what you wanted. The routine I suggested will give you the
CurrentUser's Network ID.

HTH,

George,
Thanks - I checked out the link - you didn't mean use that code to get

[quoted text clipped - 32 lines]