>I am new to win XP (home edition). We have a 5+ node peer-to-peer file server network running a Foxpro 2.6 DOS uncompiled application. The server runs under win 98 2nd
>
>When I start an non-compiled Foxpro application from an XP machine with other machines (win 95 or win98) running the application, I get a "not a database file" if another user has that file open and has used an APPEND or INSERT - SQL (as a part of a program) to add a record to that file. Once the other user has closed the database file the XP machine can use that file again.
>
>My guess is that Win XP is sensitive to the reccount() and that the records do not get updated until the file is closed by the user that has made the append.
>
>A work-around would of course be to close and open the file after the append but that seems clumsy. Is there a command that will force and update of the header?
Hi Eric,
This error has been reported when running FP2.x on a peer-to-peer network where the "server" was a Win9x machine. The problem was solved by making the WinXP machine be the "server."
See:
http://groups.google.com/groups?sourceid=navclient&ie=UTF-8&oe=UTF-8&q=foxpro+xp+%22not+a+database%22