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

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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Sunil Somani" <(E-Mail Removed)> wrote in message
news:54984EAF-84B4-4D13-AA5F-(E-Mail Removed)...
> 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/TWickera.../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/d...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

"Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
> "Sunil Somani" <(E-Mail Removed)> wrote in message
> news:54984EAF-84B4-4D13-AA5F-(E-Mail Removed)...
>> 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
>>
>
>

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

Sunil Somani wrote:
> 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
>