Security

J

John

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
 
J

John

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
 
R

Rick Brandt

John said:
Rick,

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

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.
Click to expand...


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

John

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
 
G

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
 
B

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.
 
Top