How to retrieve User name and group of a secured db vis VBA?

[Norman Fritag]

Hi there,

I would like to retrieve of a secured database the Username and the group
that he / she belongs to, to apply access rights to some button click
events, which are accessing forms that the User Usergroup doesn't have
access to.

Any idea how I would go on about it??

kind regards

Norman f

[Miss M]

I would also like to be able to do this, though I would be content
just to know the user name. I have a secured database on a laptop
that will be passed around amongst users, but we need to know who made
the last change to a record. All users will have the same Windows (XP)
login, but will login individually to the db (MSAccess 2000).

It's so easy to do this in Filemaker, but it seems as if it must be
rather obscure in Access. I have done quite a bit of hunting around
and can't seem to find anything on point.

thanks much.

Norman Fritag wrote:

Hi there,

I would like to retrieve of a secured database the Username and the group
that he / she belongs to, to apply access rights to some button click
events, which are accessing forms that the User Usergroup doesn't have
access to.

Any idea how I would go on about it??

kind regards

Norman f

[Jim Allensworth]

You can use the CurrentUser function to return the - current user.

I also recommend that you download the Security FAQ white paper. There
is much information in it regarding secured dbs.

http://support.microsoft.com/default...;en-us;q165009

- Jim

On Tue, 10 Aug 2004 16:14:52 -0400, Miss M <mm***@virginia.edu> wrote:

I would also like to be able to do this, though I would be content
just to know the user name. I have a secured database on a laptop
that will be passed around amongst users, but we need to know who made
the last change to a record. All users will have the same Windows (XP)
login, but will login individually to the db (MSAccess 2000).

It's so easy to do this in Filemaker, but it seems as if it must be
rather obscure in Access. I have done quite a bit of hunting around
and can't seem to find anything on point.

thanks much.

Norman Fritag wrote:

Hi there,

I would like to retrieve of a secured database the Username and the group
that he / she belongs to, to apply access rights to some button click
events, which are accessing forms that the User Usergroup doesn't have
access to.

Any idea how I would go on about it??

kind regards

Norman f

[Miss M]

I gather CurrentUser is not a built-in function?
I didn't see it in the list. But thanks, I hope I can
figure it out from the white paper.
m

Jim Allensworth wrote:

You can use the CurrentUser function to return the - current user.

I also recommend that you download the Security FAQ white paper. There
is much information in it regarding secured dbs.

http://support.microsoft.com/default...;en-us;q165009

- Jim

On Tue, 10 Aug 2004 16:14:52 -0400, Miss M <mm***@virginia.edu> wrote:

I would also like to be able to do this, though I would be content
just to know the user name. I have a secured database on a laptop
that will be passed around amongst users, but we need to know who made
the last change to a record. All users will have the same Windows (XP)
login, but will login individually to the db (MSAccess 2000).

It's so easy to do this in Filemaker, but it seems as if it must be
rather obscure in Access. I have done quite a bit of hunting around
and can't seem to find anything on point.

thanks much.

Norman Fritag wrote:

Hi there,

I would like to retrieve of a secured database the Username and the group
that he / she belongs to, to apply access rights to some button click
events, which are accessing forms that the User Usergroup doesn't have
access to.

Any idea how I would go on about it??

kind regards

Norman f

[Jim Allensworth]

It *is* a built-in function!

Try this; open the debug window {Ctrl} {g} and type ...

?CurrentUser
If the app is secured you will get the name of the user. If not then
you will get Admin.

?CurrentUser
Admin

Also, if you will select anywhere on the function name and type F1 you
will get help on the function.

- Jim

On Tue, 10 Aug 2004 21:29:49 -0400, Miss M <mm***@virginia.edu> wrote:

I gather CurrentUser is not a built-in function?
I didn't see it in the list. But thanks, I hope I can
figure it out from the white paper.
m

Jim Allensworth wrote:

You can use the CurrentUser function to return the - current user.

I also recommend that you download the Security FAQ white paper. There
is much information in it regarding secured dbs.

http://support.microsoft.com/default...;en-us;q165009

- Jim

On Tue, 10 Aug 2004 16:14:52 -0400, Miss M <mm***@virginia.edu> wrote:

I would also like to be able to do this, though I would be content
just to know the user name. I have a secured database on a laptop
that will be passed around amongst users, but we need to know who made
the last change to a record. All users will have the same Windows (XP)
login, but will login individually to the db (MSAccess 2000).

It's so easy to do this in Filemaker, but it seems as if it must be
rather obscure in Access. I have done quite a bit of hunting around
and can't seem to find anything on point.

thanks much.

Norman Fritag wrote:

Hi there,

I would like to retrieve of a secured database the Username and the group
that he / she belongs to, to apply access rights to some button click
events, which are accessing forms that the User Usergroup doesn't have
access to.

Any idea how I would go on about it??

kind regards

Norman f