Microsoft KB Archive/134315

= FIX: Cannot Open Database and No Message Is Displayed =

Article ID: 134315

Article Last Modified on 9/30/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition

-



This article was previously published under Q134315



SYMPTOMS
When attempting to open a Visual FoxPro database (.DBC) by using the menu options or by clicking the Open button on the Standard toolbar, Visual FoxPro does not open the database or issue a message if the database has been open exclusively by another user or in a different private data session.



CAUSE
The database is already open exclusively on a second machine or in another Visual FoxPro session on the same machine. When the database is already open, Visual FoxPro echoes the OPEN DATABASE command to the Command window, but does not execute it.



WORKAROUND
Here are three possible workarounds:
 * Attempt to open the database by executing the OPEN DATABASE command that was echoed to the Command window. The error "File Access Denied" occurs because the database is already opened exclusively. -or-


 * Execute the OPEN DATABASE command in a program. -or-


 * Open the database SHARED on all machines and in each Visual FoxPro session.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem has been fixed in Visual FoxPro 5.0 for Windows.



Steps to Reproduce Problem
In a network environment:
 * 1) Open a database exclusively.
 * 2) From a second machine running Visual FoxPro, attempt to Open the same database exclusively. On the File menu, click Open, or click the Open button on the Standard Visual FoxPro toolbar.

From one machine using two Visual FoxPro sessions:
 * 1) Open a database exclusively.
 * 2) Run Visual FoxPro a second time, keeping the first session of Visual FoxPro running. Attempt to open the same database exclusively. On the File menu, click Open, or by click the Open button on the Standard Visual FoxPro toolbar.

Additional query words: 3.00 3.00b

Keywords: kbbug kbfix kbvfp500fix KB134315

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.