467,868 Members | 1,383 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,868 developers. It's quick & easy.

Updating one table with another

Hi All,

Here's the scenario :

Table 1 : Each record has unique id
Table 2: Every time a record in Table 1 is created and/or updated
table2 stores each as a seperate record

Each time a record is added / updated a copy of the new updated record
is added to another table (this table essentially stores all the
changes to a record, it keeps the change history of a record). I want
to track all changes to records in this second table so that I can
track the change history.

I hope that is clear.

Any suggestions greatly appreciated.

Thanks in advance.

T.

Feb 14 '07 #1
  • viewed: 1399
Share:
1 Reply
Hi.
I hope that is clear.
Crystal.
Any suggestions greatly appreciated.
Don't use Jet for this. Instead, use a server database that supports
triggers. The trigger can execute whenever a record in Table 1 is updated
or a record is inserted, and put a new record in Table 2. Links to free
server databases from the major database vendors, such as Oracle, Microsoft,
and IBM, can be found on the following Web site:

http://www.backends.QBuilt.com/

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
<ta********@gmail.comwrote in message
news:11*********************@j27g2000cwj.googlegro ups.com...
Hi All,

Here's the scenario :

Table 1 : Each record has unique id
Table 2: Every time a record in Table 1 is created and/or updated
table2 stores each as a seperate record

Each time a record is added / updated a copy of the new updated record
is added to another table (this table essentially stores all the
changes to a record, it keeps the change history of a record). I want
to track all changes to records in this second table so that I can
track the change history.

I hope that is clear.

Any suggestions greatly appreciated.

Thanks in advance.

T.

Feb 14 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Jason | last post: by
4 posts views Thread by Geoff | last post: by
5 posts views Thread by aaron.m.johnson | last post: by
33 posts views Thread by bill | last post: by
2 posts views Thread by =?Utf-8?B?VmFuZXNzYQ==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.