I worked on a project once that used an Access Database, and what we did was create our own "dirty" flag at the end of the record. Basically, a one byte flag that was 0 for unchanged and 1 for changed (we actually had a more complex setup, but this would be the basic route to take). Then all you have to look at on the Access side is the recordset where DirtyFlag = 1.
-------------- Original message ----------------------
From: "Jonathan Carse" <jonathan.carse@gmai...>
> Hi Everybody,
> I have written a conduit that syncs between an Access database (using ADO)
> and the palm database.
> My problem is that since there is no way to retrieve only the "dirty"
> records from an Access database (this is available only on SQL server), I am
> forced to perform a slow sync on each sync (slow sync = comparison of all
> records on both sides).
> As my database grows well beyond 15,000 records, this is quite a speed
> Has anyone encountered a problem like this? Is there an original idea out
> there that might solve this case?
> For information on using the ACCESS Developer Forums, or to unsubscribe, please