How to transfer only new records from old_table to new_table 1

[qb828]

Hi guy!

Can someone help me?

I have a database with 100 tables. I delivered this to the client.
Mean a while I am entering new records to these tables at my site.

Once a month I need to update my client's database at another site with only new records.

Can you give your thoughts or share your wits how you would go about doing this?

can you tell me if this is one of the ways to do it:
1)query only new records since last month into a table.
2)take it to the client site.
3)import those new records into the client's database.

Another question, I have about 100 tables.
That means I need to do 100 queries and insert them to 100 tables.
and my client needs to do 100 imports to their tables.

Is there a better way to do this or is this only way?

Thanks
QB



QB

 

[luceze]

Try looking up Replication in the help files. That might be a way to handle the task.

 

[luceze]

Try this site for a basic overview.

http://www.microsoft.com/accessdev/articles/qareplc.htm

HTH,
Eric

 

[qb828]

Thanks Eric.

That is great.
I tested with small test database and it seems to work fine.

I am afraid to try on my client's project yet.
I need to search and see if there are n't any effects.
I need to find out more about it (pros and cons)
Do people use this on regular basis?

If you know more about it please let me know.
If you don't use this replication, what would be another way to do this?

I appreciate your help.

Q


QB

 

[ShelDoyal]

If what you've tried thus far doesn't work, this might...

Assuming there a unique identifier field in each table (something that is different in each record)that you set as the primary key). You could then create an append query and it will append only the new records (will get an prompt telling you that it will only append x number of ticket, the new record, you ok that and it does it). I believe the details are in the help files.

 

[dalenz]

qb828

This works but admittedly on a DB with a lot less tables.

Add a yes/no field to the table called say Updated with a default value N

Once a month append only those records with value N to your export table then update to Y