Show AllShow All

Set up a data source that uses the Microsoft Paradox driver

Before proceeding with these steps, it's a good idea to place all of the database files that you want to use together in the same folder, so that Query can find all of your files and you don't have to type the full path whenever you want to add a table to a query.

  1. If the Create New Data Source dialog box is not displayed, click New on the File menu, click the Databases tab, and then double-click New Data Source. Type a name for the data source in step 1 and select Microsoft Paradox Driver in step 2.
  2. In step 3, click Connect.
  3. In the Version box, select the version of Paradox that was used to create your database files.
  4. If the database files are not in the current folder, clear the Use current directory check box, and then click Select Directory to locate the files.
  5. If your database requires you to set advanced options, click Options. For information about whether you need to change any of these settings, see the administrator for your database. For information about the option settings, click Help on the ODBC Paradox Setup dialog box.