SinghSuperStud

iTrader: (2)

In MS Access '97, I've successfully set up a workgroup and defined user priveleges etc.

I am developing a quick database which users currentuser() and now() to input the user name and time they click on a button to be registered in a table so I can check when they are logged on. Trouble is when each user clicks enter they overwrite any previous data and only one row exists in the table - any ideas ?

All I want is a quick answer so any help appreciated !!

Thanks, Jai

S55 HOT

How are you populating the table - is it a query ?

SinghSuperStud

iTrader: (2)

No, via a form.

If I can use a form button to run a query that would be good too ! As long as it works, I don't care how !!

TolTec

If I understand what it is you are doing then...

You need to create an append query
In the Field boxes enter the data you want to add e.g MyField1:currentuser()
In the Append To boxes select the field in the table the data should go into

Use a macro on the button in your form to run the query.

Mail me if that is as clear as mud

SinghSuperStud

iTrader: (2)

Hi,

ok - that worked brilliant !

Now - is it possible that I can capture the log-in time from Windows NT rather than requiring users to load up my database and then click on form buttons etc. ? This would be so much easier

I know that I'm now really getting demanding but has Access any built in methods or utils that will let me determine when a pc is being used ? I am in charge of data-inputters and it'd be good to work out how long they're actually doing work instead of bullsh*tting that they're working when they're just lookign at the screen !!

S55 HOT

There should be something like =now() as a function

TolTec

It depends if you want to know when they open the database or when they log onto the PC really.

You could make the query run using an autoexec macro. An autoexec macro runs everytime the database is opened. You can also log when they close the DB if you want, the easiest way is to use an Exit button that runs a similar query.

If you want to log PC logins then you can enable auditing on the PC so that logins are entered in the event log (assuming you are running NT,W2k pro or XP).

You may be legally obliged to tell your staff that you are logging their work. Not sure about this but generally you have to let staff know if web access, email use, homedrives are logged and scanned.