Syncronizing 2 databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 questions...

First, if I have a table called contacts with a column called "last_update_date
I want the record in the table to reflect the most recent date the the record was changed on a form. Is this easy

Second, if I have given someone a copy of the database and they are making their own changes to the contact table, is there a way we can synchronize the contents of the table to match based on the most recent update in either contact table

Hope this makes sense.....thanks in advance for your input

Gre
 
I have 2 questions....

First, if I have a table called contacts with a column called "last_update_date"
I want the record in the table to reflect the most recent date the the record was changed on a form. Is this easy?

Second, if I have given someone a copy of the database and they are making their own changes to the contact table, is there a way we can synchronize the contents of the table to match based on the most recent update in either contact table?

Hope this makes sense.....thanks in advance for your input.

Greg
Click to expand...

Hi Greg,

First Question -

Yes, in the Form's Before Update event:

Me.last_update_date = Date()

You can use Now() instead of Date() if you want the time portion also.

Second Question -

You could use Access Replication. It's a bit complex to set up, but it
would do what you want. Check out www.trigeminal.com for a lot of info
about replication.

If you don't want to use replication, you can write your own routines to
use queries to update or append data from one database to the other.
It's cumbersome, but for a simple database it can work. If both
databases can add Contacts, and you're using AutoNumber primary keys,
you'll need to use Random or Replication ID instead of Incremental
AutoNumbers. This is one way to get unique keys in two different
databases.

Hope this helps,

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com
 
Back
Top