That's right, and that's the way it's going to work. You are going to have to reopen the tables to see the new data. You could try to re-architect both systems to use remote views, even though they run on the same system because a REQUERY() would force a refresh of the data. There may be another way to do it, like USE the table each time you need it.

>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