Security

[Guest]

I was wondering if it's possible to track who/when made changes to a record
or in general to a database design? I have a Access Xp shared by my staff on
a network. If someone makes a change, what option would I have to go back to
see who and when they made that change. Can you please explain this process
in detail? Thanks.

John

 

[Rick Brandt]

I was wondering if it's possible to track who/when made changes to a
record or in general to a database design? I have a Access Xp shared
by my staff on a network. If someone makes a change, what option
would I have to go back to see who and when they made that change.
Can you please explain this process in detail? Thanks.

John

All tables would need to have a RevisedOn and a RevisedBy field added. If
you then utilize Access built in Security where each user has to log in to
open your file then you could run code in the BeforeUpdate event of all your
forms...

Me.RevisedBy = CurrentUser()
Me.RevisedOn = Now()

If you don't want to use Access security you can use the code at the link
below instead of CurrentUser() to insert their network profile name instead.

http://www.mvps.org/access/api/api0008.htm

 

[Guest]

Rick,

1. I added two fields in my main table that I have all the data.

2. I went to the form properties and changed the beforeUpdate to event
procedure and that took me to the VB code editor. There I typed
Me.RevisedBy = CurrentUser()
Me.RevisedOn = Now()
Then created multiple user accounts and managed to log on. However, when I
tried to change something thru the form and exit, I get compile error. I'm I
missing something? Did I completely do the procedure the right way? Im knew
to all this, Please help. Thanks.

John

 

[Rick Brandt]

Rick,

1. I added two fields in my main table that I have all the data.

Do the fields also show up in the field list for the form? If your form is
bound to a query or SQL statement it might not automatically pick up new fields
that are added to the table.

2. I went to the form properties and changed the beforeUpdate to event
procedure and that took me to the VB code editor. There I typed
Me.RevisedBy = CurrentUser()
Me.RevisedOn = Now()
Then created multiple user accounts and managed to log on. However,
when I tried to change something thru the form and exit, I get
compile error. I'm I missing something? Did I completely do the
procedure the right way? Im knew to all this, Please help. Thanks.

It looks ok providing that the fields are in the form's RecordSource and that
you spelled them correctly.

 

[Guest]

Rick,

You’re awesome. You really are the best. Thank you so much.

John

 

[Guest]

Rick,

While using this useful technique, few questions came to my mind.

1. So far I can see when and who made the changes, is it possible to include
what changes???

2. I noticed it overwrites the previous entry of when and who made the
changes. For example I entered some data and went back to the table to see
if my RevisedOn and RevisedBy fields would display the previous changes. It
erased the prior entry??? What can I do to keep it.

3. What if I have a form that has a subform from another table? Adding the
two RevisedBy and RevisedOn fields to the other table would work? Would it
recognize who and where the changes were made? Thank you so much Rick.


John

 

[Rick Brandt]

Rick,

While using this useful technique, few questions came to my mind.

1. So far I can see when and who made the changes, is it possible to
include what changes???

2. I noticed it overwrites the previous entry of when and who made the
changes. For example I entered some data and went back to the table
to see if my RevisedOn and RevisedBy fields would display the
previous changes. It erased the prior entry??? What can I do to keep
it.

Okay, what you're describing now is an audit trail and that is a lot more
complicated to set up and it means storing a lot of extra data in your database.

One of the regulars in here has a sample database with an audit trail feature.
If you Google these groups you should find a link to it.

 

[Joan Wild]

One of the regulars in here has a sample database with an audit trail
feature. If you Google these groups you should find a link to it.

http://www.allenbrowne.com/AppAudit.html

 

[Guest]

Thank you very much.

http://www.allenbrowne.com/AppAudit.html

 

[greeksteve]

Joan Wild, Hi a web site yaier.com has been sending emails from my hotmail
account - how can I stop this / report this action and prevent further misuse
of my hotmail account?
Thanks,
steve clarke

 

[bcap]

You are in the wrong newsgroup. This one is for Microsoft Access, the
database product.

Having said that, if they are really using your Hotmail account then I'd
have thought that changing your password would do the trick. However, if
they are simply sending emails with a spoofed "From" address i.e. yours,
then there is absolutely nothing you or Microsoft can do to stop them,
except perhaps try to identify their ISP or hosting company and complain to
them.