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.

--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/

-------------- 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
> issue.
> Has anyone encountered a problem like this? Is there an original idea out
> there that might solve this case?
>
> Thanks,
>
> Jonathan
>
> --
> For information on using the ACCESS Developer Forums, or to unsubscribe, please
see http://www.access-company.com/developers/forums/


--
For information on using the ACCESS Developer Forums, or to unsubscribe, please see http://www.access-company.com/developers/forums/