multiple connections to same database

[Jimbob]

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

[Lafor]

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

[Jimbob]

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

[Lafor]

?

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

[Lafor]

"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!

[Jimbob]

that seems to work a treat.

thanks a lot!