Microsoft KB Archive/96155

= FastTips for FoxPro for MS-DOS: Network Issues Q&A =

ID: Q96155

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, version 2.5

Microsoft(R) Technical Support Application Note (Text File) FP0914: NETWORK ISSUES QUESTIONS & ANSWERS Revision Date: 9/93 No Disk Included The following information applies to Microsoft FoxPro(R) version 2.5 for MS-DOS(R).

| INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY    | 1. Q. When a second user runs Microsoft FoxPro for MS-DOS on my
 * ACCOMPANY THIS DOCUMENT (collectively referred to as an Application |
 * Note) IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND, EITHER     |
 * EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED     |
 * WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR      |
 * PURPOSE. The user assumes the entire risk as to the accuracy and   |
 * the use of this Application Note. This Application Note may be     |
 * copied and distributed subject to the following conditions: 1) All |
 * text must be copied without modification and all pages must be     |
 * included; 2) If software is included, all files on the disk(s)     |
 * must be copied without modification (the MS-DOS utility diskcopy is |
 * appropriate for this purpose); 3) All components of this           |
 * Application Note must be distributed together; and  4) This        |
 * Application Note may not be distributed for profit.                |
 * Copyright (C) 1993 Microsoft Corporation. All Rights Reserved      |
 * Microsoft, FoxPro, and MS-DOS are registered trademarks and Windows |
 * is a trademark of Microsoft Corporation.                           |
 * is a trademark of Microsoft Corporation.                           |

network, the error message &quot;File in use by another&quot; is      displayed. How can I correct this problem?

A. If you are on a peer-to-peer network, you first must load the MS-DOS Share program and then verify that the FoxPro files are marked as read-only. The FOXUSER database can be shared only if      the file is marked &quot;R-O&quot; (read-only). If you receive this error message when you try to open a database file, make sure that both users have EXCLUSIVE set to OFF. 2. Q. Where does FoxPro store its temporary files on a network?

A. FoxPro creates its temporary files in the current working directory unless you specifically designate an alternative location by including one or more of the EDITWORK, SORTWORK, PROGWORK, or TMPFILES statements in the CONFIG.FP file.

If the local workstations have sizable hard disk drives with plenty of free space, you can improve performance in a      multiuser environment by placing FoxPro's temporary work files on the local hard disk drive or on a RAM drive. Redirecting these files to a local hard disk drive or a RAM drive provides additional speed by reducing the need to access the network drive, therefore reducing the amount of network traffic.

On small networks with older workstations that have slower hard disk drives, better performance is sometimes obtained by      leaving FoxPro's temporary files on the file server. When in      doubt, direct FoxPro to store temporary files on a local hard disk drive. Additional reference words: FoxDos 2.50 ivrfax fasttips KBCategory: kbprg kbfasttip kbappnote KBSubcategory:

Last Reviewed: December 12, 1996