Persistence

[mb]

Hi,

what would be the best way to store a user id etc..for a multiple user
db ... and then be able to access that userid at various points in the
app ??

e.g.

user signs in with id of USER001

I want to be able to access that variable when, for example, that user
adds records to a table to track who added what ...

any help appreciated..

[Keith Wilby]

"mb" <mb**@bigfoot.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi,

what would be the best way to store a user id etc..for a multiple user
db ... and then be able to access that userid at various points in the
app ??

e.g.

user signs in with id of USER001

I want to be able to access that variable when, for example, that user
adds records to a table to track who added what ...

any help appreciated..

Access a variable when a user adds a record? I don't understand that
concept at all but you can set up a log of changes made by adding some
coding in the form's Current event. Functions you will need include Now(),
CurrentUser() and Environ (see the help for more info). You would need to
loop through all relevant controls on the form and determine which one(s)
has (have) been changed (old/new value properties) which you can then record
in a table.

Not too detailed I know but it should set you off in the right direction.

Keith.
www.keithwilby.com

[Terry Kreft]

You can persist the value in a number of ways e.g.:-
Global variable
Database property
Field in a table
An external file
The registry
Control on a form
...

and so on.

Personally, as you are using a database I would go with a field in a table,
which you can then update as appropriate and recall at any time.
--

Terry Kreft
"mb" <mb**@bigfoot.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi,

what would be the best way to store a user id etc..for a multiple user
db ... and then be able to access that userid at various points in the
app ??

e.g.

user signs in with id of USER001

I want to be able to access that variable when, for example, that user
adds records to a table to track who added what ...

any help appreciated..

[Anthony England]

"mb" <mb**@bigfoot.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi,

what would be the best way to store a user id etc..for a multiple user
db ... and then be able to access that userid at various points in the
app ??

e.g.

user signs in with id of USER001

I want to be able to access that variable when, for example, that user
adds records to a table to track who added what ...

any help appreciated..

When you say "signs in" does this mean some form of login screen? If so,
you could have it so the OK button hides this screen if the login is
successful. Then at any point you can get the value by asking for
Forms!frmLogin.txtUserID.

[Larry Linson]

As an alternative, you will find the Windows API code to retrieve the user's
network login id at http://www.mvps.org/access/api/api0008.htm and the
current computer name at http://www.mvps.org/access/api/api0008.htm. If you
do that, you will identify the user without:

-- having the user log on again, separately
-- having to climb the learning curve, which is substantial, to implement
Access' own security (and, see above), or
-- having a security lite, which is easily defeatable -- the network id
has its own, less easily defeatable, security.

Larry Linson
Microsoft Access MVP

"mb" <mb**@bigfoot.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi,

what would be the best way to store a user id etc..for a multiple user
db ... and then be able to access that userid at various points in the
app ??

e.g.

user signs in with id of USER001

I want to be able to access that variable when, for example, that user
adds records to a table to track who added what ...

any help appreciated..

[rustymorr]

I have created several databases where the user identifies himself to
the application by a login-like screen. Upon successful identification,
I did several things:

1. Made an entry in a login history table.
2. Set a global variable to the user's ID (lngCurrentUserID)

In order to easily recall the user id for queries and reports, I
created a very simple function to return the value of the global
variable:

Public Function CurrentUserID () as Long

CurrentUserID = lngCurrentUserID

End Function

Hope this is helpful,

RustyMorr

[Rusty Morr]

I have created several databases where the user identifies himself to
the application by a login-like screen. Upon successful identification,
I did several things:

1. Made an entry in a login history table.
2. Set a global variable to the user's ID (lngCurrentUserID)

In order to easily recall the user id for queries and reports, I
created a very simple function to return the value of the global
variable:

Public Function CurrentUserID () as Long

CurrentUserID = lngCurrentUserID

End Function

Hope this is helpful,

RustyMorr