multiple connections to same database

I'm running 2 apps connected to the same DB with ADO.

when I Update a row on in one, the changes are not reflected in the other app. If I check the tables in access, the changes are made. is there a way I can force my apps to refresh their connections and get the latest db

doesn't it all depend on how u open your recordset in the other app... ? adopendynamic? u need ..

that's what I thought, but it doesnt seem to be so....

?

If u don't mind, just cut/paste a caption of your sql invocation.. (Another set of eyes sometimes...)

"By default the Synchronization service is disabled and cannot be used to perform resynchronization"

If one needs synchronization, the recordset needs to be opened with a CursorLocation of adUseClient
and a LockType of adlockBatchOptimistic

with that locktype OLEDB Cursor service will create a cached rowset that lends itself to synchronization later

So, if u had a disconnected recordset
and if u had opened it the way I descried above
do this to resync

with recordset
set .active connection = actual connection
.resync
end with

Vale!

that seems to work a treat.

thanks a lot!