Checking DataBase User

[Nad]

Hi Guys,
I split my Project Update Database and i distributed the FrontEnd to the
users and i keep the BackEnd in the shared drive & its working fine.
My question is that, how can i check which user has updated the database?

Thanks for usual cooperation.

Nad

 

[Allen Browne]

By "updated the database" do you mean modified the forms/reports?
Or do you mean who last changed the data?

Access does not give you either, but you can add fields to your tables to
record the Windows user name and/or computer name of the person who last
modified a particular record. Use the BeforeUpdate event procedure of the
form to write the information into the field.

Network user name:
http://www.mvps.org/access/api/api0008.htm

Computer name:
http://www.mvps.org/access/api/api0009.htm

Of course, if you have secured the database, you could just use
CurrentUser().

If you need a working example of how to get these, download this sample
database:
Splash screen with version info
from:
http://allenbrowne.com/ser-53.html