Wrox Programmer Forums
|
Pro VB 6 For advanced Visual Basic coders working in version 6 (not .NET). Beginning-level questions will be redirected to other forums, including Beginning VB 6.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Pro VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 21st, 2008, 10:35 AM
Authorized User
 
Join Date: Apr 2008
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Creating an Audit Trail

Hello,
As my subject indicates, I have to create an Audit Trail. I have to log the old info and the new added to the database. I've been trying to think of the codes to do this but I'm coming up blank. Searching online for ideas has proven to be futile.

Can anyone help please?

Jade

 
Old October 22nd, 2008, 03:30 AM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Hi

Can you elaborate if you are planning to use a database (Access / SQL Server etc)

Are you having the data in one or more tables

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)
 
Old October 22nd, 2008, 09:18 AM
Authorized User
 
Join Date: Apr 2008
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'll be using SQL Server 2000 and the data will be stored in different tables. I hope this is enough information.

Jade

 
Old October 23rd, 2008, 12:44 AM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Hi Jade

Please check if the following link helps you

http://www.go4expert.com/forums/showthread.php?t=301

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)





Similar Threads
Thread Thread Starter Forum Replies Last Post
Infopath Audit Trail sqaengineer Infopath 0 August 13th, 2007 10:10 AM
Crumb trail muks XSLT 8 October 6th, 2006 03:15 AM
BizTalk trail download josekarun Biztalk 0 August 4th, 2006 10:52 AM
JavaScript trail for books varelg Javascript 1 April 25th, 2004 07:39 PM
XML/XSL BreadCrumb Trail fortgjort XSLT 8 August 28th, 2003 04:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.