First, the PerVMFiles=nnn setting applies ONLY to Windows Millennium computers. All other Windows versions still use FILES=nnn (up to 225 I think, but in most cases 80 to 100 is more than enough) in a CONFIG.SYS or CONFIG.NT file.
With Windows XP locate and modify the file CONFIG.NT which should be in the C:\Windows\system32 directory. That should resolve any issues where you might get the "Too many files open" error.
Now, as for your problem, you left out some important information. Does your XP have SP1 installed? Are you on a network? Are the tables on the server or computer on the network? If so, you may have locking/saving/buffering issues.
Review the responses on these similar complaints with other versions and languages to see if any help in your case. Then, post back here to let us know what worked or didn't work.
thread290-726910
I saw your post on thread290-704687 and wonder if you've tried this workaround logic to get the computer to write a buffered record to the table:
APPEND BLANK
GO RECNO()
I agree that it would be awkward to close and reopen a table every time a record is appended.
I know FoxPro had a command named FLUSH that was supposed to save all buffered data, but I don't know if recent dBase versions have a command like that.
I found a thread182-655739 mentioning opportunistic locking. The following articles refer to NT, but nothing was changed in W2K, so this still applies.
- "PC Ext: Explanation of Opportunistic Locking on Windows NT" and
- "Level II Oplocks Are Not Granted After a File Is Locked".
On another thread182-686206 I found this: Opportunistic Locking on the server can affect this. There's also a bug with XP clients that was fixed in XP Service Pack 1.
To disable Opportunistic Locking manually on a Windows 2000/XP Workstation computer:
1. Enter the OplocksDisabled entry into the below registry key:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MRXSmb\Parameters
OplocksDisabled REG_DWORD 0 or 1
Default: 0 (not disabled)
2. Set the value to 1 to disable Oplocks
3. Reboot the workstation computer.