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

  • Thread starter Thread starter Sunil Somani
  • Start date Start date
S

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
 
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
 
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
 
Back
Top