PRB: No Tables Listed in RecordSource of Data Control

ID: Q118647

The information in this article applies to:

Microsoft Visual Basic Professional Edition 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

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

Q119591 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.

Additional query words: 3.00

Keywords :
Version : WINDOWS:3.0
Platform : WINDOWS
Issue type :