Thanks for the confirmation. We can leave the tables closed at application startup, and then each form will open and close the tables as needed, which seems to take care of the problem. I just wanted to make sure that the behavior we were seeing was correct.

Thanks for the help,
Chris Vesper

>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