Chris,
Check thread 313297 (1/5/2000 and 1/7/2000) for VMP-specific information on this topic. Basically, VMP does a USE AGAIN in its forms. This speeds opening each form, but does NOT reliably refresh the data from the server.
Barbara
>Hi, we're having a data refresh problem with a a multi-user VFP 5 application, and I'm hoping someone can help.
>
>We can run two copies of the same application on one computer (as an EXE) both using the same data files. One copy adds some records to a table, and the other workstation can't seem see those records. For example, workstation A adds some transaction records to a table, then workstation B runs a report on that table, and the new records do not show up. If I exit from the application on workstation B, and re-start it, the report will now show the records.
>
>All the tables are opened at application startup (in the default data session) and just about all the forms use private data sessions. I've found that if I DON'T open the tables at application startup (so they're not open at application startup) then the added records are visible.
>
>We have SET REFRESH TO 0, 30 and we even stuck a timer on the main switchboard form that does a FLUSH every 15 seconds, but no luck. It only seems to work if we don't pre-open the tables in the default data session.
>
>Some notes...we're using Stonefield 5.0i, and MaxFrame Pro 3.
>
>Any ideas?
>Chris Vesper
>
cvesper@marquise.com