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

Updating one table with another

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.