History Table

[nayfeh]

How can I setup a history table in access? I'd like the exact same fields, but an additional field that records when the records were copied to the history table. Any ideas?

Thanks,
TN

 

[thornmastr]

This topic has pretty much been beaten to death. Go to

http://www.google.com.

Go to groups computer database and do a search on History table. You might also want to search on audit tables as well.

Good luck. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[K3ith]

Hello,
I am attempting to achieve very much the same thing, as yourself, if I make any progress I will let you know and if you could do the same this would be appreciated.

Thanks
Keith

 

[thornmastr]

Perhaps this will get you started om your quest.

http://users.bigpond.net.au/abrowne1/ser-37.html

Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com