The Tables and Environment tabs in the FoxWeb Error Log should be able to tell you the status of EXCLUSIVE and REPROCESS while the error occurred.
Sent by James Williams on 02/06/2007 05:56:28 AM:
Do you create any temp tables on disk in the script that is causing the problem?
Sent by Joe Goldsmith on 01/10/2007 12:09:04 AM:
No takers on the problem?
Sent by Joe Goldsmith on 12/23/2006 06:17:19 PM:
Hi all. Every once in a while I find an error in the FoxWeb error log that a file is already open by another user. I can't understnd why this is so. The project's options under the data tab is
unchecked for Open exclusive
Automatic file locking is unchecked
multiple record locks is checked
Buffering is record optimistic
reprocessing is set to Attempt lock
All data fetches, updates, and adds are done through SQL commands. Most Select statements use one or more QueryString parameters.
The most recent error where the file is already open by another is a Select to our inventory table using the Full-Text Search Engine. Would anyone have an idea show this occured and perhaps how to eliminate it?