Track changes

[Nicole]

Hello:

I have a shared database running on a network drive. I would like to
track when record changes occur and who did it.

Problem 1: I'm not able to tack changes, when they occur in subforms.
(I have a main form with 3 subforms)

Problem 2: for CurrentUser I'm currently getting "admin", since I
don't have any security levels set up, however everybody in our system
has to look on each machine here, is it possible to read the general
user NetID and put it in my filed CurrentUser?

I would really appreciate any help.

Nicole

BeforeUpdate Event:
Me![Last Change] = CurrentUser() & " " & Now()

[MGFoster]

Nicole wrote:

Hello:

I have a shared database running on a network drive. I would like to
track when record changes occur and who did it.

Problem 1: I'm not able to tack changes, when they occur in subforms.
(I have a main form with 3 subforms)

Problem 2: for CurrentUser I'm currently getting "admin", since I
don't have any security levels set up, however everybody in our system
has to look on each machine here, is it possible to read the general
user NetID and put it in my filed CurrentUser?

I would really appreciate any help.

Nicole

BeforeUpdate Event:
Me![Last Change] = CurrentUser() & " " & Now()

See the Microsoft KB article Q148835 for procedures to get the NT logon
name:

http://support.microsoft.com/default...35&Product=acc

MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[Pieter Linden]

nv****@gmx.de (Nicole) wrote in message news:<72******* *************** ****@posting.go ogle.com>...

Hello:

I have a shared database running on a network drive. I would like to
track when record changes occur and who did it.

Problem 1: I'm not able to tack changes, when they occur in subforms.
(I have a main form with 3 subforms)

Problem 2: for CurrentUser I'm currently getting "admin", since I
don't have any security levels set up, however everybody in our system
has to look on each machine here, is it possible to read the general
user NetID and put it in my filed CurrentUser?

I would really appreciate any help.

Nicole

BeforeUpdate Event:
Me![Last Change] = CurrentUser() & " " & Now()

Problem 2:
here's a link that will grab the Login name of the current user.
http://www.mvps.org/access/api/api0008.htm

Also, I would store the "LastChange " in two different fields,
something like:
ModifyDateStamp Date/Time Format: General Date
ModifiedByUser Text(25)

Then you could handle that quite easily and search for records changed
on specific days or date ranges and by specific users.

There's also an explanation, and I think code, available at Allen
Browne's website to track changes to records in a database.

See: http://members.iinet.net.au/~allenbrowne/AppAudit.html

[Nicole]

thx guys nicole

[Tony Toews]

starwars <no****@tatooin e.homelinux.net > wrote:

Comments: This message did not originate from the Sender address above.
It was remailed automatically by anonymizing remailer software.
Another posting from the seriously disturbed person.
Interested in meeting in a public place somewhere in Deutschland to trade
computer tips?

Nicole, this person is not at all representative of the people in this newsgroup.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm