jonathanchye
Registered User.
- Local time
- Today, 04:50
- Joined
- Mar 8, 2011
- Messages
- 448
Hi all,
Just want to confirm what I am thinking is correct.
I've ran an Append Query to select certain fields from the old DB to add it into the preformatted table in the new DB. This preformatted table is based on the table from the old DB but it has slightly different fields.
The Append Query seemed successfull so far. So now my new DB's table data mirrors the old one.
However, the old DB is still live at the moment but is due to be taken down soon so I will need to run a query to constantly update the data in the new DB in the mean time.
Let's say during this time the user adds a few new records in the old DB and modify some information on the older records in the old DB. What query should I run to correctly mirror this on my new DB's table?
As I understand it Append Query will only add new records so it won't go through the old records?
Should I just wait until the last minute, clear all data in my new table and run the Append Query once?
Thanks.
Just want to confirm what I am thinking is correct.
I've ran an Append Query to select certain fields from the old DB to add it into the preformatted table in the new DB. This preformatted table is based on the table from the old DB but it has slightly different fields.
The Append Query seemed successfull so far. So now my new DB's table data mirrors the old one.
However, the old DB is still live at the moment but is due to be taken down soon so I will need to run a query to constantly update the data in the new DB in the mean time.
Let's say during this time the user adds a few new records in the old DB and modify some information on the older records in the old DB. What query should I run to correctly mirror this on my new DB's table?
As I understand it Append Query will only add new records so it won't go through the old records?
Should I just wait until the last minute, clear all data in my new table and run the Append Query once?
Thanks.