DOCUMENT:Q171215  10-JUL-1997  [vbwin]
TITLE   :HOWTO: Use Data Form Wizard to Connect to Remote Data via DAO
PRODUCT :Microsoft Visual Basic for Windows
PROD/VER:5.0
OPER/SYS:WINDOWS
KEYWORDS:vb5all VBKBDB kbhowto

======================================================================
---------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Visual Basic Professional and Enterprise Editions for
   Windows, version 5.0
---------------------------------------------------------------------

SUMMARY
=======

The Data Form Wizard allows the user to create a quick form that can access
many types of data, including remote data. This article explains how to
connect to a Remote Data Source through DAO. This is possible if a link is
established from the Access MDB file to the remote data source.

MORE INFORMATION
================

1. Create a new project and select the Add-Ins menu, Add-In Manager, and
   then select Visual Basic Data Form Wizard.

2. The Add-Ins menu contains the option "Data Form Wizard." Select this
   and, in the second screen, select Access as the Database Format.


3. The next screen will ask for the Database Name. This database needs to
   be created in Access where the user will simply "Link" the remote
   database to the Access MDB file. (See Access online Help if you
   need to know how to link a file.)

   NOTE: This assumes that a Remote Data Source (DSN) has been created in
   the ODBC Data Source Administrator.

4. Select the Form Type, choose Next, and then select the Record Source,
   choosing whatever fields you would like to have appear on the form.

5. Choose Finish, name the form, and run it. The user is now accessing a
   Remote database from the Wizard-generated form via DAO.

REFERENCES
==========

For more information about linking databases, search for "Linking Files to
an Access Database" in the Microsoft Access Help menu.

For more information about using the Data Form Wizard, search for "Data
Form Wizard" in Microsoft Visual Basic 5 Help.
======================================================================
Keywords            : vb5all VBKBDB kbhowto
Technology          : kbDAO
Version             : 5.0
Platform            : WINDOWS

=============================================================================

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.

Copyright Microsoft Corporation 1997.