Updating from a local database to a central database.

[1druid1]

Database: Access 2007

Hi All

I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.

Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.

What is the best way to do this?

Cheers

DJ

 

[spikepl]

There was a thread on this involving lengthy discussions .. back a year or two.

Google this site, search for point of sale