PRB: No Tables Listed in RecordSource of Data Control (118647)



The information in this article applies to:

  • Microsoft Visual Basic Professional Edition for Windows 3.0

This article was previously published under Q118647

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 Download Center:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

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.

Modification Type:MinorLast Reviewed:8/9/2004
Keywords:kbdownload kb16bitonly kbfile kbprb kbSample KB118647 kbAudDeveloper