Add Secure DB User ID to table

Hi All

I have an Access 2000 Database that has been secured using user groups.

When you open the database it asks for a name and a password.

I want to see who is adding information to the database.

Is there a way to add the Name of the user to tables in my database.

E.g. If they add a record to the database table I would like it to auto populate a field called DBUser with that user's name?

Can this be done?

Any help would be much appriciated.

JP

Take a look at the attached database. Open the Main Switchboard...but none of the buttons work and they are not important in this situation. Upon opening and closing the form, user name, machine name, date, time in, and time out information is recorded in the LoginLogout table.

You can do what you are asking. And this should get you on the right start...just take a look at the coding...take a look how everything works. If you need more help please PM me! Thanks!

OOPS forgot to supply the database. Here it is:

Thanks tarcona.

That is exactly what I needed.

Also, I've just learned a bit about using DAO - which was a bonus!

Many Thanks Again

JP