PRB: No Tables Listed in RecordSource of Data Control

 Last reviewed: February 5, 1997
Article ID: Q118647
The information in this article applies to:
  • Professional Edition of Microsoft Visual Basic for Windows, version 3.0

SYMPTOMS

In Windows version 3.x, the data control may fail to properly bring up a list of available tables for the RecordSource property even if the proper path and database name are specified in the DatabaseName property of the data control.

CAUSE

This problem may be caused by not loading the SHARE.EXE file before you run Visual Basic.

RESOLUTION

There are two ways to add the file-sharing capability to Windows version 3.x:

  • If you are running Microsoft Windows 3.0 or Windows 3.1 (that is, not Windows for Workgroups), you need to change your AUTOEXEC.BAT file to read as follows: 

            SHARE /L:500 /F:5100

   If SHARE is already in your AUTOEXEC.BAT file, it must include the L and
   F switches. If the /L or the /F setting for SHARE has a larger value
   than listed here, leave the setting as it is rather than reducing it.
  • Download VSHARE.386 and install it on your system. VSHARE.386 is compressed under the filename WW1000.EXE.

The following file is available for download from the Microsoft Software Library: 

 ~ Ww1000.exe (size: 22455 bytes)
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from
               Online Services

STATUS

This behavior is by design.

NOTE: SHARE.EXE is required for data access in both the Standard and Professional editions of Visual Basic for Windows, version 3.0; the README.TXT file is not explicit that SHARE.EXE is required by the data control.

MORE INFORMATION

SHARE or VSHARE is required by the Microsoft Access Jet database engine. Microsoft Access needs to share in order to create some temporary files that it uses when accessing database tables.

KBCategory: kbprg kbfile kbprb kbinterop
KBSubCategory: APrgDataAcc APrgDataIISAM
Additional reference words: 3.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 5, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.