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

documenting table changes in A97

P: n/a
MLH
What's a good approach to documenting changes made
in a multi-user database. Take the generic example of a
table tblSalesProspects used by a dozen sales persons in
a company's Sales Department. Perhaps its been discussed
before but I'm at a loss to find related threads.

The field are quite typical - something like FName, LName,
CompanyName, Addr, City, State, Zip ... phones and email
and other contact info. And maybe a single memo field.

Say on Tuesday, Ashley logs in and opens the Woodard
Cabinets record. Say she changes the [FAX] field and [LName]
field. I would like to note the fact that CurrentUser modified
these two specific fields in tblLOG (or tblProspectTableMods)
for future reference. How best can one notice which fields
have been modified immediately prior to the SAVE event?
Objective: Prevent finger pointing amongst sales staff should
Bob log in on Thursday and change [LName] field again.
Oct 14 '06 #1
Share this Question
Share on Google+
9 Replies


P: n/a

"MLH" <CR**@NorthState.netschreef in bericht news:68********************************@4ax.com...
What's a good approach to documenting changes made
in a multi-user database. Take the generic example of a
table tblSalesProspects used by a dozen sales persons in
a company's Sales Department. Perhaps its been discussed
before but I'm at a loss to find related threads.
Did you *really* search ?? I find this *very* hard to believe.
It took me only 5 seconds to find what you need...

Search this group for words like 'log ' 'edits' 'trail' and such.

Arno R
Oct 14 '06 #2

P: n/a
MLH
No I did't search arno. I just figured
you'd answer the Q. Thx
Oct 14 '06 #3

P: n/a

MLH wrote:
No I did't search arno. I just figured
you'd answer the Q. Thx
Wow. And you call yourself a professional. Hilarious. I'll give you a
hint. AuditTrail.

Oct 14 '06 #4

P: n/a
Did you *really* search ?? I find this *very* hard to believe.
It took me only 5 seconds to find what you need...

Search this group for words like 'log ' 'edits' 'trail' and such.

Arno R
Looks like he missed the satire in Terry's clsProgrammer class.
Somehow explaining it to him would take all the fun out of it.

Oct 14 '06 #5

P: n/a
MLH wrote:
No I did't search arno. I just figured
you'd answer the Q. Thx
That's it. You are a moron.

PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK
PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK
PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK
PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK
PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK
PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK
PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK
PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK
PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK
PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK
PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK
PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK PLONK

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Oct 15 '06 #6

P: n/a
MLH
Thanks for taking the time to answer my question.
Oct 15 '06 #7

P: n/a

"MLH" <CR**@NorthState.netschreef in bericht news:vs********************************@4ax.com...
No I did't search arno. I just figured
you'd answer the Q. Thx
So you figured right.
I indeed answered your question (as pietlinden did also).
What's wrong with searching the ng ??

A wise man said something like:
"If you give a person some fish he/she can eat for one day
If you teach a person to fish he/she can eat every day..."

I am sure you still like fishing.

Arno R
Oct 15 '06 #8

P: n/a

MLH wrote:
Thanks for taking the time to answer my question.
I'm utterly amazed. You profess to write Access databases for a
living, but you're too lazy to do basic things like:
1. test things out for yourself.
2. search the help file.
3. search the NG for posts that might answer your question.

Why not take some time trying to answer your own question and then post
what you tried when you can't solve it by yourself? What, are you
afraid you might actually learn something? No wonder you still haven't
quite mastered A97.

Oct 15 '06 #9

P: n/a
pi********@hotmail.com wrote:
MLH wrote:
>>Thanks for taking the time to answer my question.

I'm utterly amazed. You profess to write Access databases for a
Everyone should plonk this lazy git. USually one sees newbies start to
help with answering questions after a short while, but this "please do
my work for me" fellow has been around for 3 years or more and does
nothing but continue to display a disdain for even pressing F1.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me
Oct 16 '06 #10

This discussion thread is closed

Replies have been disabled for this discussion.