By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,500 Members | 830 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,500 IT Pros & Developers. It's quick & easy.

Track changes

P: n/a
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()
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Nov 12 '05 #2

P: n/a
nv****@gmx.de (Nicole) wrote in message news:<72**************************@posting.google. 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
Nov 12 '05 #3

P: n/a
thx guys nicole
Nov 12 '05 #4

P: n/a
starwars <no****@tatooine.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
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.