ADP Data Refresh

[kcmccc]

I have an ADP w/ SQL 2000. Multiple users use the same form, a list-view of records. Because the ADP does not refresh data on a regular interval as an MDB does, if a user updates data in one record, the other users do not see that new data unless they manually click refresh. What I need is a way to automate the refresh on a regular interval. I have tried a timer event, but the refresh/requery forces the cursor back to the first record in the list.
Any suggestions would be greatly appreciated!

 

[cmmrfrds]

Try reading up on the ResyncCommand, but I am not sure if it applies here.

http://www.tek-tips.com/viewthread.cfm?SQID=894886&SPID=958&page=1

 

[cjowsey]

You're right, Requery can be a nuisance. You need to save the record number (your unique key) and navigate back to it after the refresh or requery. You then have to watch out for the screen repainting itself too many times.

I didn't find an easy way around it. I changed some forms with this issue to unbound and got around it that way.