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     |
| ACCOMPANY THIS DOCUMENT (collectively referred to as an Application |
| Note) IS PROVIDED "AS IS" 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.                            |
|  -------------------------------------------------------------------|

1. Q. When a second user runs Microsoft FoxPro for MS-DOS on my

       network, the error message "File in use by another" 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 "R-O" (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