Compare or Sync Tables (*Tough Question*)

[kramerica]

Here's the dilemna.

Reporting tool exists on several different machines. (Not Central the clients that use the tool are located in different locations with no connectivity amoungst themselves.)

The reporting tool uses a couple of key tables that store 'static' data in them. Once the data is in the tables it is usually never changed. (ie. Code / Amount / Description)

If I have several users using the tool.. and user "A" is very industrious and types in much of the static data - I would like them to be able to 'Export' the data to another user so that they each don't have to type in the data.

What I need is - a VB solution that will allow field by field compare of the export table to detemine if it should append the entire RECORD or prompt the end user to 'sync' if they are different. The current logic is that If the record does not exist in the current reporting tool, but does exist in the IMPORT Table - Then just import it. It it does EXIST IN BOTH TABLES - check field by field and look for discrepancies. IF they match then skip the record.

I have to do this with 5 Tables and I am using Recordsets to do the looping and field comparison. Is there a better way? How do you pass a field name to a function and utilize it in a RS!Fieldname

 

[mp9]

Replication?

http://www22.brinkster.com/accessory/

 

[MichaelRed]

Have you looked into simple update queries?




MichaelRed
m.red@att.net

Searching for employment in all the wrong places