Syncronizing Tables in Two different Databases

[GriffG]

I am currently trying to take two databases and syncronise them, I have two tables in each and they both need to be done.

the first one will never have any duplicate rows as the primary key is based on a machine the software is interfacing with and a Timestamp. If the best way to sync this table to copy one table into one of the DB's and then merge them, then overwrite the other DB's table with the merged one.

the other table has changes and additions that can be made. I have a changes table that records added records and edited records. this way I know which row need to be updated, again the question I am asking is how would I copy the table from one DB to another and insert it into a temporary table.

I am doing this from a Sync Program I am making in VB.Net and I am using the JET system to connect to the Databases.

 

[PHV]

If your databases are MS-Access you may consider Replica

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[GriffG]

I am trying to use replication to syncronise the tables. I have a couple of problems that I need help with, first of all the application I am building is using two databases, the first database has the forms and queries in it, along with some tables, the other database is a data database, it only contains tables (this was designed by a person with no DB expirenece) .

There are a couple of tables in the data DB that need to be syncronised, one table will never have duplicates so they only ever need to be merged, the other table has Assets in it and there can be changes to the asset information and new assets can be added.

The first problem I have is I need to have a button on a form in the program DB that inisiates the replication process, I have a button on there that has the code DoCmd.RunCommand acCmdSynchronizeNow. I get an error on that saying that it cannot procced as there is at least one object open. (I assume it is the form I am clicking the button on)

The second problem I have is how do I set this up so that the syncronisation will happen through a serial cable to the remote replica without having to specify its location.

once I have this problem fixed I need to find a way to use a serial cable to do the syncronisation.