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