G
Guest
I have a main database with a backup database. The main database has one
table that is very important so with each new record added to the main table,
I run an append query to adds that record to the backup database table.
Updates are made to the initial records from time to time, and what I'd like
to do is run an update query that will compare the main database table with
the backup database table to make updates that were made to the main table
after the append query ran (this only adds new records). I know I could
import the table to the backup each time, but this can be a headache. This
is easy to do within the same database, but any help on update queries
between two databases would be a life saver!
Thanks
table that is very important so with each new record added to the main table,
I run an append query to adds that record to the backup database table.
Updates are made to the initial records from time to time, and what I'd like
to do is run an update query that will compare the main database table with
the backup database table to make updates that were made to the main table
after the append query ran (this only adds new records). I know I could
import the table to the backup each time, but this can be a headache. This
is easy to do within the same database, but any help on update queries
between two databases would be a life saver!
Thanks