who did it? (1 Viewer)

[wh00t]

Hi all

I have created a db which is used by around 80 people, there is a problem which happens frequently, but in order to fix the problem, I need to know how it occurs. Fixing it will not be a problem, I know the general area of the problem but can not pin it down.

each person logs onto the db (access security)

here's what I want to do.

I want to record against a certain record, what user has changed the record.

I already have code in which updates a field for the record telling me which form was used to update the record. But I need the user aswell.

 

[skunk711]

The in-built function CurrentUser() returns the user logged in at the time.

You can use that and store it in a record when it is saved or updated. This will enable you to see who the last person who changed the record.

 

[Hayley Baxter]

An example of how to do this is attached in the following thread.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30421

HTH
Hay