Access- How to log which user has modified access db?

[Sunil Somani]

Hi All,

We have one MS Access database, which is being shared/accessed by number of
users at the same moment. Few of them are admin users too who can perform
update/delete/insert operations too.

Now we have a requirement to log which users has perform which update
operations. Is there some way, can you please advise.

Thank you so much in advance,

Best regards,
Sunil Somani

 

[Arvin Meyer [MVP]]

If you have User Level security enabled, you can add a column to each table
and call the CurrentUser() function and add that user in the before update
event of the form. Without that, you can use the fOSUserName function from
the Access Web:

http://www.mvps.org/access/api/api0008.htm

 

[Gina Whipp]

Sunil,

In addition to what Arvin said, it didn't sound like your application is
split. You will need to do that... You actually should do that anyway.
Here's some information on splitting.

http://www.members.shaw.ca/AlbertKallal/Articles/split/

http://allenbrowne.com/ser-01.html


You may also want to take a look at MVP Tom Wickerath's article...

http://www.accessmvp.com:80/TWickerath/articles/multiuser.htm


To handle the update of multiple front ends see...

http://www.autofeupdater.com/


If each user needs Access you can install the Runtime...

http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John Spencer]

Depending on the complexity of what you need to do, you may need to implement
an audit log or a transaction log. To do this in Access take a look at Allen
Browne's method.

Audit Trail - Log changes at the record level at:
http://allenbrowne.com/AppAudit.html

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County