users on access

  • Thread starter Rahul Chatterjee
  • Start date
R

Rahul Chatterjee

Hello All

I am trying to write a simple database in access. It will consist of
multiple tables one for each client group that we have (I know this is
against DB design but this is the way that it needs to be). There will be a
controlling form when the user opens access and the user will select the
appropriate group and the subsequent form that loads up should access that
particular client table (All the data structure in each table would be the
same) and display that information.

Also when a particular user loads up a table, I want to be able to find out
who all are in the database table (THe database is going to be on the
network and multiple people can use it)

Can anyone help me (with examples preferably) as to how to do this

Thanks
 
G

Guest

hi,
a suggestion.
Put a text box in your form for the user name. for it
control source use
=currentuser - this will get the user name if they are
listed in a access group and have a database password
=environ("username") - with will get their network logon
name.
You can then create a table to house the user name, time
long on, time long off
undate the user name and logon time with an apend query in
the forms open event.
udate the logoff time in the forms close event.
regards
 
Top